Skip to content
Advertisement

SQL how to prevent masking by like statement

I’m dealing with a masking issue with the like statement such that:

The newname UTI will be masking UTI ADDRESS and OP will be masking OP HH, how should I avoid this masking issue?

Thank you!

Advertisement

Answer

You put the conditions in a better order:

Actually, it may be better to order them by length:

This should help you ensure that there are no “masking” conflicts.

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement