Archives of the TeradataForum
Message Posted: Fri, 15 Dec 2006 @ 16:45:44 GMT
I'm trying to find bad data in a character field. The correct format should be numbers only in the first four positions, followed by an 'M' in the 5th position. In SQL Server, I would write something like,
WHERE field1 LIKE( '[0-9][0-9][0-9][0-9][0-9,M]')
Is there anything equivalent in Teradata?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|