>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
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 opt
