How to use a ":" inside a SQL string for MS Access

<i><b>Originally posted by : Justin (justin.whitehead@bxs.com)</b></i><br />I am trying to select a column based upon a similiar string such as this: "blah:blah", but the : (colon) seems to mess it up. For example,<br /><br />SELECT * FROM table WHERE LIKE 'no: 3';<br /><br />Anyone know how to get around this? Thanks.

<i><b>Originally posted by : MArkkk (E49340@dteenergy.com)</b></i><br />How about:<br /><br />SELECT * FROM table WHERE FieldName LIKE '%:%'<br />or<br />SELECT * FROM table WHERE FieldName LIKE '%no: 3%'<br /><br /><br /><br />1. Your SQL Statement doesn't appear to have a 'FieldName'.<br /><br />2. You must use the SQL wildcard (%)...even with Access<br /><br />I hopethis helps<br /><br /><br />------------<br />Justin at 6/17/2002 4:28:58 PM<br /><br />I am trying to select a column based upon a similiar string such as this: "blah:blah", but the : (colon) seems to mess it up. For example,<br /><br />SELECT * FROM table WHERE LIKE 'no: 3';<br /><br />Anyone know how to get around this? Thanks.