sql Help
I have a ten character field and need to exclude records if the first 2 character equal a specific pattern how do you do that?
Software/Hardware used:
Software/Hardware used:
ASKED:
May 11, 2009 5:21 PM
UPDATED:
May 11, 2009 5:53 PM
Answer Wiki:
<pre>SELECT *
FROM your_table
WHERE your_field NOT LIKE 'XX%'</pre>
In this case XX is the two-character pattern.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
