There is field called "text" and it is concatenated with the delimiter '##'.
How to select all the values before the delimiter '##'
And
How to select all the values after the delimiter '##'
| SitePoint Sponsor |


There is field called "text" and it is concatenated with the delimiter '##'.
How to select all the values before the delimiter '##'
And
How to select all the values after the delimiter '##'


which database system? MS Access? Informix? DB2?


I am using MySql database


does the data have any single # characters in it? or just the double?
Bookmarks