Hi all,
I am having table JobDetail whcih contains jiobname as a one of column.here the data entered from front end is not correct because of space issue.
for example if job name is Software engineer then it might be entered single space or sometimes multiple spaces between "Software" & "engineer". but while selecting i want only once.I am using distinct but giving wrong output. Please suggest any idea.
thanks
Abhas