Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 How to Select all rows starting with numbers and s

Author  Topic 

jag17
Starting Member

4 Posts

Posted - 2008-02-01 : 09:10:57
Hi

I have a table with one column

Shop Name
---------------
123 Shop
#56 Shop
@Shop
Astar Shop
Best Shop


I want to write a sql select statement and produces the following result

Shop Name
---------------
123 Shop
#56 Shop
@Shop


Please help me on this

Cheers
-Jag

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-02-01 : 09:39:48
Please dont duplicate your posts:-
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=96600
Go to Top of Page
   

- Advertisement -