length of the string


length of the string

Hi I want to know how to do something like this in teradata

(case when LENGHT(a.address) > 5 then a.address else a.other_address end)

If the lenght of the address is greater than 5 characters then I am assuming that the address is correct, else want to take address from a different field...

thanks in advance
Tags (1)

Re: length of the string

Use the standard SQL function CHARACTER_LENGTH.