knowram Posted October 5, 2007 Share Posted October 5, 2007 is there a way to say Select * from Device Where Name doesn't start with A how do you do the doesn't start with part? thanks for the help Quote Link to comment Share on other sites More sharing options...
corbin Posted October 5, 2007 Share Posted October 5, 2007 NOT LIKE 'A%' Look into the LIKE clause ;p. Quote Link to comment Share on other sites More sharing options...
knowram Posted October 5, 2007 Author Share Posted October 5, 2007 Thanks i have still haven't figured out wild cards. Quote Link to comment Share on other sites More sharing options...
corbin Posted October 5, 2007 Share Posted October 5, 2007 If you know the cmd style *, then the % is basically the same with SQL. Also, in MSSQL (and maybe MySQL as well), you can use brackets to do choices. For example: A% would be A and then anything else following A. %A would be anything with an A on the end. [ABC]% would be anything that starts with A B or C. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.