What would the WHERE statement be to select records with a caret (^) anywhere in a field.
If my data looks like this:
Sang; f^ete the^atrale.
I dont want the position or anything I, I just want to find records with the caret in them.
select * from BIB_TEXT where BIB_TEXT.TITLE = '%^^'