|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
how can i test a cast before it throws an errori have CAST([PhoneWork] AS bigint) in my select statement. if the varchar
has non-integer characters, how can i test the cast because its throwing errors right now Check ISNUMERIC() in the BOL
HTH, Jens Suessmeyer. Show quote "Abraham Luna" <a**@rdk.com> wrote in message news:ONFI5ULtFHA.3080@TK2MSFTNGP15.phx.gbl... >i have CAST([PhoneWork] AS bigint) in my select statement. if the varchar >has non-integer characters, how can i test the cast because its throwing >errors right now > thank you, gonna create my first function :)
Show quote "ML" <M*@discussions.microsoft.com> wrote in message news:9A470410-1796-46EB-B604-B53FFE26268E@microsoft.com... > And after that read this: > http://www.aspfaq.com/show.asp?id=2390 > > > ML  |
|||||||||||||||||||||||
Other interesting topics