Hi Richard, Many thanks, that works. Why do I need the "()" around my calculation? (apart from 'because that makes it work' !) I've used other dbms's and don't need them there.
Cheers, Dave Ward Analytics Ltd - information in motion Tel: +44 (0) 118 9740191 Fax: +44 (0) 118 9740192 www: http://www.ward-analytics.com Registered office address: The Oriel, Sydenham Road, Guildford, Surrey, United Kingdom, GU1 3SR Registered company number: 3917021 Registered in England and Wales. -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: 31 May 2013 16:46 To: General Discussion of SQLite Database Subject: Re: [sqlite] Concatenating literals with column values On Fri, May 31, 2013 at 11:38 AM, Dave Wellman <dwell...@ward-analytics.com>wrote: > Running the following SQL does not seem to give consistent results. > select stepid ,'STEPID'||stepid ,stepid+5 ,'STEPID'||stepid+5 > ,'STEPID'||5 > > Maybe for column D you intended to say: 'STEPID'||(stepid+5) -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
