Tara-1044200
SSCoach
Points: 15951
More actions
January 28, 2010 at 11:46 am
#209547
I need to select a VArchar field where in it has any numbers.
Lynn Pettis
SSC Guru
Points: 442467
January 28, 2010 at 11:48 am
#1110273
Tara-1044200 (1/28/2010)I need to select a VArchar field where in it has any numbers.
Tara-1044200 (1/28/2010)
select ... where varcharcol like '%[0-9]%'
Does that help?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply