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