I need to suuply an exact number of bytes in a database dump. When using
VARCHAR(21) and only using 18 characters, how do you fill in the rest
with forced spaces?
-
Before posting, please check:
From: Jeff Small (NWCC) [EMAIL PROTECTED]
...how do you fill in the rest with forced spaces?
char pads, but you may not want to alter your database. Why do you ~have~ to have 21
bytes? Can the device you're pulling this data into be modified to handle things more
intelegently? Another
I need to suuply an exact number of bytes in a database dump. When using VARCHAR(21)
and only using 18 characters, how do you fill in the rest with forced spaces?
Take a look at the LPAD() and RPAD() functions.
HTH
/Rob
~
Robert Alexander, Alpha Geek,