Archives of the TeradataForum
Message Posted: Fri, 11 Jan 2013 @ 13:46:03 GMT
I have a question.
In my Table I have a column with datatype varchar and data have numeric and non-numeric data
I want to display like numeric to numeric and non-numeric to null
100 Null 200 Null 33000
If I tried with like
Sel case when col1 is between 0 to 100000 then col1 else null end from tablename
I am getting an error.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|