sql server2000 a string that contains digits only 2

[duchovnick]

Hi,
In my table there's a string type column.
I want it to contain digits only.
I want to see all lines with that string having any other character
but a digit.
I search a code that will do something like

SELECT
myStringCol
WHERE
All characters>='0' AND
all_characters<='9'

"All charcters" is my "wishfull thinking" And i'd like to ask someone
who is more realistic then i am to tell me what "All characrers"
should be replaced with.
Thanks a lot !

 

[earthandfire]

Have a look at the PATINDEX function, that should do what you need.


Hope this helps.

 

[Otto]

Try this:

 ... where COL like '%[^0-9]%'

Returns with all rows having not numeric character in COL.

 

[gmmastros]

Take a look at this Frequently Asked Question. faq183-6423

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[duchovnick]

Hi Otto
I ran your code changing it into "not like rather than like and it worked OK!
thanks A LOT !
HI Earhandfire
Either i didnt understand it or it didnt match excactly my need, I couldnt use the PATINDEX keyword.
And thank you GMMastros !