RE: SQL Select Statement

["Cotes, Steven" <cotess@xxxxxxxxxxx>]

John,
almost there,
Use the single quotes, but preface any imbedded quotes with an
additional
quote. ie 'JANUARY''98'
Also be aware that January'98 <> JANUARY'98 because of case.

 -HTH,
 -Steve Cotes
 -cotess@data-io.com

> ----------
> From:         John Hall[SMTP:jhall@hillmgt.com]
> Sent:         Tuesday, January 27, 1998 5:56 AM
> To:   MIDRANGE-L@midrange.com
> 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.
> 
> We are on V3R2.
> 
> John Hall
> Home Sales Co.
> +---
> | 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
> +---
> 
+---
| 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
+---