Hello all,
I have some private details that need to be outputted replacing some characters with Stars. I would like to do this on the SELECT statement, rather than in PHP as this would be more secure. IE:
Oracle: 102030
SQL Select: XXXX30 or 30
PHP: XXXX30 or XXXX30
I don't mind formatting the output in PHP - just want the SELECT Command to SELECT the last 2 characters of a column.
Regards,
Matt