How to Select all rows starting with numbers and spl chars - DML (SELECT, INSERT, UPDATE, DELETE) Questions

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » Transact-SQL Programming » DML (SELECT, INSERT, UPDATE, DELETE) Questions » How to Select all rows starting with numbers and spl chars

How to Select all rows starting with numbers and spl chars

Options

Previous Topic · Next Topic

jag17

Posted: Friday, February 01, 2008 8:21:55 AM

Rank: Newbie

Joined: 1/27/2008
Posts: 2
Points: 6
Location: SG

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

wdismukes

Posted: Saturday, February 02, 2008 7:49:22 AM

Rank: PFY

Joined: 5/3/2007
Posts: 20
Points: -37
Location: Houston, Texas

http://technet.microsoft.com/en-us/library/ms179859.aspx

Scott Whigham

Posted: Tuesday, February 05, 2008 2:20:13 PM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

I would also add the question, "What's different about the rows you want vs the rows you don't want?" I'm not naive enough to think you really want those values.

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.