There is an old function NULLIFZERO(col), which is the same as a NULLIF(col, 0).
NULLIFSPACES doesn't exists, but this should be NULLIF(col, '')
Dieter
Thnx Dieter for explaining...
in the format function why we always use this format --
SELECT CAST ((545458874489 (FORMAT '99-999-999-9999')) AS CHAR (15)) AS Format_Cast_PhoneNum
and not this --
SELECT CAST ((545458874489 (FORMAT '11-111-111-1111')) AS CHAR (15)) AS Format_Cast_PhoneNum
Banerjee
9 is the formatting character representing a numerical digit - stolen from COBOL oh so long ago.
Thanx Todd
hello there
i have got an offer as teradata developer as fresher..
i would like to know how the real time environment would be like.. please help me with this..
i want to know atleast how to work on it before entering into the organization
thanks in advance
If you are joining as a fresher, am sure the organization will guide you through it.
Cheers.
-- If you are stuck at something .... consider it an opportunity to think anew.
Hi, masters
can please haelp me
i have a scenario like
col1 col2 col3........col37is like(sam,xyz,abc,cdef,xxxxx)..........col50............col247
here i need to use delimeter ', ' but if i taking that it is dividing the 37th column into different columns but i need that entire column as one not diff can please help me how to do this problem
Thanks in advance
Ram
Here
The column name itself has the delimiter as ',' not data
Ram
Please post your question in a seperate thread and be more descriptive.
-- If you are stuck at something .... consider it an opportunity to think anew.
Is there any function called NULLIFSPACES invoked in Teradata 13 version? If yes or it present before please explain how it works,syntax,uses etc..