Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

LEFT function in query criteria

Status
Not open for further replies.

peitzza

Technical User
Apr 13, 2000
80
US
i want to exclude all the values in my query that have an &quot;*&quot; at the start of the text string in the field &quot;Group/Name&quot;. i tried to do this but i couldn't get it to work. any help would be greatly appreciated!&nbsp;&nbsp;thanx in advance, Peter. <p>Peter Heaton<br><a href=mailto:heaton@characterlink.net>heaton@characterlink.net</a><br><a href= it how ever you want</a><br>
 
<br><br><br>Try this :<br><br>&quot;SELECT * from table1 WHERE left([group],1) &lt;&gt; '*'&quot;<br><br> <p>Amiel<br><a href=mailto:amielzz@netscape.net>amielzz@netscape.net</a><br><a href= > </a><br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top