Could anyone know how to find the tab, linefeed and carriage return present in a column. Suppose I have a column emp_det, I want to find the number of rows which are having tabs, linefeed and carriage return. I tried as: sel count(1) from db1.emp where emp_det ='% %' ;--In between 2 %, I have kept one tab. The output showing is wrong. This is for tab. Don't know about linefeed and carriage return. Do anyone have any suggestion ?
Thanks for your reply. I tried but, i think chr function is not available in TERADATA.
sel count(1) from db1.emp where emp_det ='%' || CHR(9) || '%' $ *** Failure 3706 Syntax error: expected something between '(' and the integer '9'. Statement# 1, Info =55 *** Total elapsed time was 1 second.