Field width

[MdVries]

Hello everyone,

I want to have my adres field at an bigger width. (80 char)

This is my code.

SELECT *,;
IIF(LENC(caddress1) => 0, "contact", "persoon") AS src,;
IIF(LENC(caddress1) => 0, cacct_name, pacct_name) AS bedr_naam,;
IIF(LENC(caddress1) => 0, caddress1, paddress1) AS adres;
into CURSOR rol;

Can someone help me with this?

 

[Mike Gagnon]

Take a look at the PADL,PADR etc.. in the help file

SELECT PADR(address,80) as addr1 FROM customer

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
ReFox XI (www.mcrgsoftware.com)