Hi @Yacovs ,
Is the length of each data in your salary column the same? I guess it should be different. If the length of each data in the salary column is the same, that is, a fixed value, then you can try:
select len(salary) LenSalary from yourtable
then:
select cast(salary as varchar(The fixed value from the previous step))+'%' from yourtable
But this should not be the case.The actual length of each value in your salary column should be different, and the parameter in varchar can only be a fixed value, so your idea cannot be realized.
Please also try:
select cast(salary as varchar)+'%' from yourtable
If you have any question, please feel free to let me know.
If the response is helpful, please click "Accept Answer" and upvote it.
Regards
Echo
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.