Archives of the TeradataForum
Message Posted: Mon, 22 Oct 2001 @ 19:17:45 GMT
One possible answer is as follows. You can use a CAST function either inside the case statement on each clause (ex. CAST(nnnn as INTEGER) or you could wrap a CASE statement around the entire CASE statement ex.
CAST((CASE....WHEN....THEN....ELSE....) AS INTEGER)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|