Archives of the TeradataForum

Message Posted: Mon, 15 Jul 2013 @ 19:45:10 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi all,

Would anyone have any advice / thoughts on how best to approach the following?

One of our users is querying a production table and for a specific column (this column is of variable length and is a mixture of numerical and alpha characters) they wish to test, for each row, does it have less than or equal to 6 numerical characters.

If it has up to 6 numeric chars, then, they wish to set a counter and flag the check as a pass but if it has more then 6 numerical characters, then, they wish to set a counter and flag the check as a fail.

i.e. they wish to check each position in the row of that column and confirm if it is a numeric, if so count it, if not ignore it. If the count of numeric chars for that row in that column crosses a count of 6 numeric chars then this row fails the check, if less then or equal to a count of 6 numeric chars then it passes the check.

The option of stored procedures etc is not available to them due to site security restrictions so they are looking to code in sql

Would appre any input

Thanks Anne

	<Prev	Next>		<<First	<Prev	Next>	Last>>