All Forums Teradata Applications
sayaksitex 24 posts Joined 09/12
11 Sep 2012
To find if the column is notnull, if the column contains ( , ,'',-), if the column is valid decimal(15) in a single query

we want a single query for checking

1. if the column is null or not

2. if it is not null then we should check that it doesnt contain  , - '' 

3. if the above 2 cases are passed , we want to check if it is a valid decimal(15) or not



You must sign in to leave a comment.