how can i test a cast before it throws an error

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 nowCheck ISNUMERIC() in the BOL
HTH, Jens Suessmeyer.
"Abraham Luna" <abe@.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
>|||And after that read this:
http://www.aspfaq.com/show.asp?id=2390
ML|||thank you, gonna create my first function :)
"ML" <ML@.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