Hello guys. > > I have a small problem.I am trying to write some sql queries. Whenever i > put a semicolon, sqlite returns an error immediately.for instance if i > select as follows > > Select Surname||", "||First_Name||" ; "||Address as "Details > >From Person > where PersID=1098
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
