Hallo. I need help. I have record (text1||text2) in field. I know, that is not good practice. So, i need to read these record, find simbol's "||" and to delete this simbol's. How to make this?
the instr function will allow to find a string within a string.
then use the left$ and right$ functions to create a string excluding the symbol |. Then update the column with the new data.
