I need to select variable1 with only a length of 3 from the data below
I only need the following records in the output:
Thnaks for your help in advance
where characters(variable1) = 3
Thank you for the prompt response. I am currently using sql server and it is not recognizing this function.
Why did you ask for help with SQL Server in a Teradata forum?
Btw, in TD14 there's also SQL Server's LENGHT function.
you can use CHARACTER_LENGTH in TD.