• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 430
  • Last Modified:

SQL query to select records with a caret (^) anywhere in a field.

Hi there

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 = '%^^'

Open in new window

0
vandersk
Asked:
vandersk
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
what about this:
select *  from BIB_TEXT where BIB_TEXT.TITLE = '%^%'

Open in new window

0
 
Smart_ManCommented:
%^%
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now