Hello,

I would like to know how to combine upper with multiple like.
Somone told me how to do it but I can't remember how it was
I suppose it is all about correct brackets

I would appreciate if you could help me build a correct statement using cat (why not) example:

cat like '%fat%'
cat like '%fluffy%'

I would like to see how to combine both likes and upper functions.


Thanks in advance

I do not know what netezza is, but to answer your question:



Or similarly

Thank you, but how to combine both fluffy and fat in one statement together with upper

combine in what way?

Upper (cat) like '%FLUFFY%' and Upper (cat) like '%FAT%'
Upper (cat) like '%FLUFFY%' or Upper (cat) like '%FAT%'
Upper (cat) like '%FLUFFY%FAT%'
Upper (cat) like '%FAT%FLUFFY%'

Thanks