vendredi 3 juillet 2015

sqlite3 apply substring to blob

I have a field that contains two values, separated by a coma and stored as BLOB, such as en these examples:

values 13,0 0,120 192,12

I am trying to create a SELECT query which only spits out the value on the right side of the coma.

I would need to cast the values-BLOB into a string in order to be able to apply instr() and substr(). How should I do that? Can somebody help my out?

Aucun commentaire:

Enregistrer un commentaire