Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    94

    Unanswered: varchar contain numbers

    Hi,

    I have a varchar column contain 'abcd' or '12345' like either character or number.

    Is there any way to find out which rows contain only number?

    please reply.

    Ram.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    where isnumeric(column_name) = 1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •