mainrotor
asked on
I need help padding a column with a leading 0
Hi Experts,
I need to create a query that will return a list of disctint Social Security Numbers from my Students table. The problem I have is that some of the Social Security Numbers in my SSN column are only 8 characters long. How can I add a leading 0 to socials that are only 8 characters long?
Thanks in advance,
mrotor
I need to create a query that will return a list of disctint Social Security Numbers from my Students table. The problem I have is that some of the Social Security Numbers in my SSN column are only 8 characters long. How can I add a leading 0 to socials that are only 8 characters long?
Thanks in advance,
mrotor
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
my bad, it's 9 you're looking for.
Very unexpected that you would send some points my way. But, I appreciate it.
Thanks for the grade & good luck.
Thanks for the grade & good luck.