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.
Code:sql = "SELECT [content] FROM DC_VendorDetails_Temp " objDB.OpenDataSet(dsrepeater, sql) dsrepeater.Tables(0).TableName = "DC" dsrepeater.DataSetName = "DC"




Reply With Quote