Sorry it was actually quite simple for the WHERE clause it should be
WHERE Name LIKE '2_%'
to select Name that starts with the string "2_"
thx> From: [EMAIL PROTECTED]> To: sqlite-users@sqlite.org> Date: Wed, 9 Apr
2008 18:21:28 -0400> Subject: [sqlite] Select row names that start with this
string...> > > I have search google but have not found a solution. I have a
field called Name and I want to select the rows that have Name starts with
certain string. How could I do this?> > SELECT Name, BuildNum AS 'Build',
ComputerName AS 'Computer Name', Time AS 'TimeStamp', Description, OSType FROM
blackboxes WHERE LEFT(Name,2) LIKE '2_' ORDER BY Time DESC;> > unfortunately
LEFT isnt a sqlite function.> > Vin>
_________________________________________________________________> Going green?
See the top 12 foods to eat organic.>
http://green.msn.com/galleries/photos/photos.aspx?gid=164&ocid=T003MSN51N1653A>
_______________________________________________> sqlite-users mailing list>
sqlite-users@sqlite.org>
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_________________________________________________________________
Get in touch in an instant. Get Windows Live Messenger now.
http://www.windowslive.com/messenger/overview.html?ocid=TXT_TAGLM_WL_Refresh_getintouch_042008
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users