Hi to all,
I have a question. Can we remove punctuation, spaces and capitalization from the field using DB2 SQL query or not? Actually, I come to the point where I need to compare a field excluding all the punctuation, spaces and capitalization. In other words just including alpha-numeric characters. Is there any DB2 SQL function to return just alpha-numeric characters out of string field?
If there is any confusion or any further question, please feel free to ask me.