sql with substring to a special character with sqlite

Question

I have values with following format in a table in sqlite:

AAAAAAAAAA#BBBBBBBBBB

AAAA#BBBBBBBBBB

AAAAAAAAAAAAAAAAA#BBBBBBBBBBB

I would like to create a SQL where I get the following result:

AAAAAAAAAA

AAAA

AAAAAAAAAAAAAAAAA

In other words. I would like to get the substring from 0->character #. How can I do this ?

Answer 1

Please try:

SUBSTR(col,1,INSTR(col,'#') -1)

Can be found at: http://www.sqlite.org/lang_corefunc.html