DSXchange

Can you suggest any idea on below requirement

The below criteria/keyword i want to search from a text field/column coming from source.

1)C/O
2)C / O
3)C.O


1)COMPANY
2)C O M P A N Y
3)C.O.M.P.A.N.Y

-I want to find out all records where any of these combination would be there.
-Both key word should be adjeacent to each other.
-Combination should include upper or lower case.

any idea how to make a efficient way to deal with

Only these combinations or more ?

DS User

There are many simmilar combination. But to get a efficient idea related to above comination would more then enough to progress on rest.

QualityStage.