How to Select all rows starting with numbers and spl chars

Question

Viewing 5 posts - 1 through 5 (of 5 total)

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

Andras Belokosztolszki SSC-Insane Points: 22031 More actions · Answer 1

Use the LIKE keyword:

select [Shop Name] from mytable where [Shop Name] like '[0-9]%'

for numbers, or

select [Shop Name] from mytable where [Shop Name] like '[^a-zA-Z]%'

for ones that do not start with a letter

Regards,

Andras

Andras Belokosztolszki, MCPD, PhD
GoldenGate Software

poztme Grasshopper Points: 15 More actions · Answer 2

Thanks Andras

But this doesn't select rows starting with special characters like #,%,* etc.

How do I write a single query to select all rows starting with numbers and spl characters

poztme Grasshopper Points: 15 More actions · Answer 3

sorry andras

my mistake. I didnt notice the second query though

Cheers

-Jag

Andras Belokosztolszki SSC-Insane Points: 22031 More actions · Answer 4

poztme (2/1/2008)
sorry andras
my mistake. I didnt notice the second query though
Cheers
-Jag

Not your fault, I've added it later (the title of your post was truncated so I did not see the "and spl chars"). Hope this works for you.

Andras

Andras Belokosztolszki, MCPD, PhD
GoldenGate Software