Roger said: > The reason i need a semicolon is because, i am creating some queries for > my reports and there are instances i concatenate some fields which i > then seperate via a semicolon, but they occur in one line e.g. for the > above query > > Smith, John ; South Africa
Roger, Your best bet would be to use the sqlite prepared statement interface. You can bind whatever you would like into the parameters and everything will be happy. Alternatively you can scan your strings for the ';' character and replace it with '\;'. This method isn't as nice, but if the prepared statement interface isn't available it's a good alternative. Clay Dowling -- Simple Content Management http://www.ceamus.com
