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:
However this statement does not include Partnumbers such as S-2000 or even S1234.Code:"SELECT * FROM Database WHERE Partnumber >= 'S'"
Then I thought of adding an ! to the statement so it would include these values:
This would produce the results I wanted....I was just wondering if there was a better way of doing this...without tacking on the !.Code:"SELECT * FROM Database WHERE Partnumber >= 'S!'"




Reply With Quote