All Forums Database
blueshot 3 posts Joined 03/12
07 Aug 2012
syntax for searching by wildcards


I'm pretty new to Teradata coding and have a question on syntax for searching using widcards...

I have a filed in my database that has a 4 digit code and I want to seach for when one of the digits in the 4 char code is a specific number. for example, the field contains the following values:

record1 - 0010

record2 - 1010

record3 - 1000

I would like to be able to pull records that have a 1 as the third digit ( **1* ) and in this case it would return record1 and record2 but not record3.

What syntax would I use? I've tried % but that looks for anything preceeding or post.

ulrich 816 posts Joined 09/09
07 Aug 2012


like '__1_'


feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

You must sign in to leave a comment.