Posted by jaawaad on 11/02/53 11:52

I have a text field in a table that contains number along with chars.
Is there a way i can write a query to show all the fields that contains
just Numbers or Char in a field??

TBALE Example

COL1 : COL2(nvarchar)
---------------------------
100 345G01
200 123456789
300 GQ9220

• Next in forum: Re: I HATE Management Studio, how about you?
• Prev in forum: I HATE Management Studio, how about you?
• Thread view: Search Char in SQL query

[Reply to this message]