Archives of the TeradataForum
Message Posted: Fri, 02 May 2008 @ 10:27:21 GMT
<-- Anonymously Posted: Fri, 2 May 2008 10:50 -->
I need to find patterns in a varchar field like '%R[0-9]%'
which means an 'R' combined with a digit and no spaces between in any position of the string.
How can I formulate such a condition in SQL?
How would I have to do it, if I'd look for '%R[0-9][0-9]%' which means an R combined with 2 following digits?
Any help appreciated
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|