Wildcard searches with zero length strings

[rgordley]

SQL 7 will not properly perform this query<br>
SELECT * FROM TABLE WHERE FIELD LIKE 'A%'<br>
when the field contains zero length strings. In a table where only a few records actually contained values and the default value of the field was &quot;&quot; such a query returned the entire table. For various reasons I do not wish to have the default value be NULL. Is there anyway around this??

 

[calahans]

I haven't come accross this problem. You could try use the CONTAINS predicate:<br>
<br>
SELECT Column1 FROM Tab1<br>
WHERE CONTAINS(Column1, ' &quot;A&quot; ')<br>
<br>
note that this search unlike the LIKE is case sensitive<br>
<br>
Cal<br>
<br>
<br>