Home > IT Answers > Development > result shoud be like that pls *****sal**** in sql
Madina287
5 pts.
 result shoud be like that pls *****sal**** in sql
SQL
  
select ENAME, sal, (LPAD(SA,(4,'*')RPD) IS NOT WORKING. 
THE RESULT SHOULD BE LIKE THAT WY.
ENAME, ***SAL**** 
THANKS.


Software/Hardware used:
yes
ASKED: January 10, 2010  7:01 PM
UPDATED: August 8, 2010  2:50 AM
RELATED QUESTIONS
Answer Wiki:
select ENAME, concat('****',SAL,'****');
Last Wiki Answer Submitted:  January 11, 2010  3:41 pm  by  MarcLight   15 pts.
All Answer Wiki Contributors:  MarcLight   15 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

What database platform are you using?

Denny Cherry
 64,550 pts.
 

Also, what exactly do you mean by ‘IS NOT WORKING’ ? Are you getting an error message ? are you getting wrong results ?

Some example data could be useful as well.

carlosdl
 63,580 pts.