Susan Harkins
harkins at iglou.com
Fri Aug 15 11:34:53 CDT 2003
Can you assign ~ to a constant? Susan H. Dear List: I'm using Option Compare Binary in a module to get the code to recognize that the tilde character "~" is greater than any alphanumeric character. (Using Option Compare Database it sorts the tilde up front.) However when I assemble and run a SQL statement that has fld >= "0" and fld <= "~" it return zero records. If I switch it around so that it says fld >= "~" and fld <= "0" the right number of records is returned. I found this out when I took the SQL and pasted it into a query and tested the criterion both ways. So apparently the Option Compare Binary doesn't extend to string comparisons when executing a SQL statement (reasonable). Is there a way to get the same Compare effect in a SQL statement? Thanks in advance to all and regards, Rocky Smolin Beach Access Software ------------------------------------------------------------------------------ _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030815/99bd9f51/attachment-0001.html>