[sqlite] Select row names that start with this string...

[Xuanvinh Vu]

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