View Single Post
  #3  
Old November 20th, 2003, 06:36 AM
Sax&Dotty Sax&Dotty is offline
Blocked From MTU.Community
 
Join Date: Jan 2003
Posts: 2
Single quote problem

quote
Please note... when you are importing tracks where you enter the Song name and Artist names, please DO NOT ever use the " (double quote) character. We have to use that to delineate a ' (single quote) character, and when a " is encountered, it will lock up the system.

Using quotes in sql is simple so long as U know where U is is at with it

Sample

where (((ArtistName)Like '*Nat*')) AND (((ArtistName)Like '*"King"*')) And (((ArtistName)Like '*Cole*'))

Just watching

Last edited by Sax&Dotty; November 20th, 2003 at 07:20 AM.