Post reply

checking for alphabets in a string

  • October 6, 2005 at 7:33 am

    #169131

    How can I check If there are any alphabests in one gievn string. If I found any of the alphabests I need to omit that string for my further process. The string should have only numbers and a period(.).

     

    Thanks.

  • October 6, 2005 at 7:43 am

    #595463

    You can use a function called ISNUMERIC that

    determines whether an expression is a valid numeric type.

    Please check BOL(Book on-line) for further information.

    Thanks

    RN

  • October 6, 2005 at 7:55 am

    #595469

    sahana - try eliminating using pattern matching and see if you get the right resultset back...

    select * from myTable

    where myColumn like '[^a-z,A-Z]'







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply