lunchbox88
Programmer
Is there a way to use the SQL LPAD function in an Access query?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
LPAD function in Access?
- Thread starter lunchbox88
- Start date
- Status
Cant find it but did find
Want the best answers? See FAQ181-2886
Code:
sLPadFake = Right("xxxxxxxx" & sLPadFake,8)Want the best answers? See FAQ181-2886
CajunCenturion
Programmer
The LSet and RSet functions are very fast because they use memory move instructions rather than string handline.
ResultString = Space(<desired length>)
LSet/RSet ResultString = "The Text"
Good Luck
--------------
To get the most from your Tek-Tips experience, please read FAQ181-2886
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein
ResultString = Space(<desired length>)
LSet/RSet ResultString = "The Text"
Good Luck
--------------
To get the most from your Tek-Tips experience, please read FAQ181-2886
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question