[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