Quick question about SQL

[Mithyrl]

Just a quick question...

I am building an SQL statement to pull all values out of a database that begin with the letter S and over...I wrote something like:


"SELECT * FROM Database WHERE Partnumber >= 'S'"


However this statement does not include Partnumbers such as S-2000 or even S1234.

Then I thought of adding an ! to the statement so it would include these values:


"SELECT * FROM Database WHERE Partnumber >= 'S!'"


This would produce the results I wanted....I was just wondering if there was a better way of doing this...without tacking on the !.

[Clunietp]

Use the LIKE statement with a wildcard ( % ) for character searching:

SELECT * FROM Database WHERE Partnumber LIKE 'S%'

[JHausmann]

And, if you're using Access and the "%" wildcard doesn't work, try "*" in its place

[666539]

Try using the like operator with the % and _

the % stands in for a substring of 0 or more characters

example

select * from table where string like 'S%'

the _ stands for exactly one character

example

select * from table where string like 'S__'

I know the statement with like % will probably work for you. I've had that work with Microsoft SQL server. I don't have any experinece using the underscore but from what I've read in SAMS publishing SQL Unleashed that should work.

[Mithyrl]

The LIKE statement with operator works nicely to retrieve all of the S items nicely. I thank you all for the help.

I just added it with an OR to my original statement to create the desired results.


SELECT * FROM Database WHERE Partnumber LIKE 'S%' OR Partnumber >= 'S'


Thanks again :)