[FWTools] sql string functions for shapefiles in ogrinfo

[Bryan Keith]

Hello,

I can use this command and get the output I expect from a shapefile:

ogrinfo "myfile.shp" -al -sql "select * from 'myfile' where ID = 'SB-18'"

However, what if I want all records where ID starts with 'SB'?  If I 
tried left, substr and others e.g.:

where left(ID,2) = 'SB'

I assume if you're using a db like PostGIS then the sql is parsed by the 
db, and you can read the db documentation for the sql syntax.  Which sql 
syntax reference should I be using for shapefiles?

Bryan