SQL select string

[daniel50096230]

I have the following data in my [content] column:

STORE NO : 908 FFDC SIMPANG PULAI (908) TEL : 03-42518482 FAX:03-42604102 FROM DATE : 01/01/09 TO DATE : 31/01/09

How should I write my sql statement so that I can only get the date after "FROM DATE: " and another data after "TO DATE: "???

Currently I have the following code which store the whole content to dataset,but I just want to select 01/01/09 and 31/01/09 to separate column in dataset.


sql = "SELECT [content] FROM DC_VendorDetails_Temp "
objDB.OpenDataSet(dsrepeater, sql)
dsrepeater.Tables(0).TableName = "DC"
dsrepeater.DataSetName = "DC"

[dglienna]

Fix the tables, so that they are in columns. That's what a table is supposed to be.