Re: SQL Select Statement

Hi, Folks:

Another simple solution is
   WHERE INVOICE LIKE 'JAN%98' - but it's less specific.


Dennis Lovelady               Simpsonville, SC
life: dennis@lovelady.com     work: dennis.lovelady@kemet.com
www: http://cybercity.piedmont.net/~dennis
ICQ UIN: 5734860   



Amit.Mukherjee@smed.com on 01/27/98 12:59:35 PM
To: MIDRANGE-Lamidrange.com <MIDRANGE-L@midrange.com> @ INTERNET
cc:  
Subject: Re: SQL Select Statement

Try   WHERE INVOICE = 'JANUARY''98'




owner-midrange-l@midrange.com on 01/27/98 08:04:04 AM
Please respond to MIDRANGE-L@midrange.com @ Internet
To: MIDRANGE-L@midrange.com @ Internet
cc:
Subject: SQL Select Statement

I need to do a select statement for the following string


January'98

ex: WHERE INVOICE = 'JANUARY'98'

I would normally include the String in single quotes - but since there
is already a single quote this returns an error : Token 98 not valid

Double quotes also gives me an error message.

ex: WHERE INVOICE = "JANUARY'98"

Column "JANUARY'98" not in specified tables.

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---