Does Teradata allow the use of functions within the LIKE predicate evaluation? For example, can the following code be done in Teradata.
Where t1.f1 LIKE '%SUBSTR(t2.f2,1,3)%'
Thanks
DSquare
I have searched through the FAQ and did not find an answer to my question/problem. I'm am working on DBC Release V2R.04.01.01.01, DBS Version 04.01.01.06. I am trying to strip out the leading numbers that are found in and address field. For example, 123 MAIN ST translates to MAIN ST. The...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.