try using single ticks instead of quotes:Select Surname||', '||First_Name||' ; '||Address as "Details" ...
This is the more correct(in SQL) way of specifying a string. John On 3/9/06, Clay Dowling <[EMAIL PROTECTED]> wrote: > > 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 > >
