Loading

Datatable.select(querry expression)

kumar thiru

hi guys
i am using datatable in my application, where i store data which has a group id like 101-2,101-3,101-1-0,102-2-1,102-2-2-1 ,101-1
i want to retrive the rows which are similar to 101-* or 101-1-*(*=[0-9])
please guide me with the relevant SQL QUERY

Kumaran

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jan Montano19y ago
select * from table where field like '101-%'
select * from table where field like '101-1-%'

Is this what you're looking for?