[thelist] SQL Server: How Can I Convert VARCHAR to INT?

Joshua Olson joshua at alphashop.net
Thu Aug 16 11:15:27 CDT 2001


I'm not a MS-SQL guru, but can you use the CASE-WHEN conditional, and check
for IsNumeric or something?

Anybody have any idea what I am talking about?

-joshua

----- Original Message -----
From: "James Aylard" <webmaster at equilon-mrc.com>
Subject: Re: [thelist] SQL Server: How Can I Convert VARCHAR to INT?


: Chris,
:
: > cast(value as type) ?
:
:     Unfortunately, CAST throws an error when it encounters non-numeric
data.
:
: James Aylard





More information about the thelist mailing list