SQL - help needed - Printable Version
-Shoutbox (https://shoutbox.menthix.net)
+-- Forum: MsgHelp Archive (/forumdisplay.php?fid=58)
+--- Forum: Skype & Technology (/forumdisplay.php?fid=9)
+---- Forum: Tech Talk (/forumdisplay.php?fid=17)
+----- Thread: SQL - help needed (/showthread.php?tid=54903)
SQL - help needed by Dempsey on 01-13-2006 at 01:24 PM
Is it possible to have a WHERE clause in an SQL statement to check if a field contains a certain string?
There is a field that contains 3 to 4 numbers, a dot, then some more numbers, eg:
234.456
1345.123
234.004
931.631
How can I retrive just the records that have 234. as the first section? Can you check for parts of a field in a WHERE clause?
RE: SQL - help needed by -dt- on 01-13-2006 at 01:36 PM
WHERE field LIKE '234%'
something like that would work
RE: SQL - help needed by Dempsey on 01-13-2006 at 02:34 PM
didn't think it would be that simple, cheers -dt- 