How to Retrieve data from a memo field
Posted on 2004-10-11
I need your help !
Working with VB6, I have an Access database table (accessed with DAO) named "Table1" with a single MEMO field, named "Field1" and containing text lines (i.e. separated with CHR(13) & CHR(10))
I want to retrieve the 4 first characters of every line of every record. For example
1st record :
2nd record :
3rd record :
I want to get the following data :
... but I'm unable to write the right SQL query ! Is it possible ?
Thank's for your help