SUBSTR and the LIKE Predicate

[dsquare]

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

 

[OraCool]

try this:
Where t1.f1 LIKE '%'||SUBSTR(t2.f2,1,3)||'%'

Did it work?

 

[dsquare]

It appears as if this works.

Thanks,
DSquare