Text String Leading Zeros

[Guest]

I have text strings in a field called HRID. I'm looking for a function that
will examine each item in HRID. If the length of the string equals 6, then
leave it as is. If less than 6, then add whatever number of leading zeros is
required to make the text string exactly 6 characters in length.

Any help would be appreciated!

 

[Dirk Goldgar]

I have text strings in a field called HRID. I'm looking for a
function that will examine each item in HRID. If the length of the
string equals 6, then leave it as is. If less than 6, then add
whatever number of leading zeros is required to make the text string
exactly 6 characters in length.

Any help would be appreciated!

UPDATE YourTable
SET HRID = Right("000000" & HRID, 6);

 

[Marshall Barton]

I have text strings in a field called HRID. I'm looking for a function that
will examine each item in HRID. If the length of the string equals 6, then
leave it as is. If less than 6, then add whatever number of leading zeros is
required to make the text string exactly 6 characters in length.

Right("000000" & HRID, 6)

 

[Dirk Goldgar]

Right("000000" & HRID, 6)

Hah! Beat you by 15 minutes!

 

[Marshall Barton]

"Marshall Barton" wrote

Hah! Beat you by 15 minutes!

I've lost a step since I was your age ;-)