i want to put two fields in one field

[MdVries]

i want to put two fields in one field

code is:
Aanhef.dear_desc + Persoon.dsp_naam AS TEST

my result is this:
"dear john "

i want my result to be:
"dear john"

how can i do that?

i have tryed:
LEFT(Aanhef.dear_desc,LEN(Aanhef.dear_desc)) + Persoon.dsp_naam AS TEST

but with the same results

 

[ChrisRChamberlain]

MdVries

[COLOR=blue]lcNewField = ALLT(Aanhef.dear_desc) ;
[tab]+ [ ] ;
[tab]+ ALLT(Persoon.dsp_naam)[/color]

FAQ184-2483 - answering getting answered.​

Chris
PDFcommander^tm.net
PDFcommander^tm.com

 

[bborissov]

If you use it in SELECT you must PAD the result. You will get a weird result if the first record contans has a smaller length, and you didn't pad it

SELECT PADR(ALLT(Aanhef.dear_desc) ;
    + [ ] ;
    + ALLT(Persoon.dsp_naam), 80) ...

Borislav Borissov

 

[Mike Lewis]

Another way:

SELECT PADR(Aanhef.dear_desc) - ALLT(Persoon.dsp_naam), 80) ...

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[alvechurchdata]

SELECT PADR(Aanhef.dear_desc) - ALLT(Persoon.dsp_naam), 80) ...

The "-" operator removes the spaces before concatenating two strings so you'll get "dearjohn" from this. You need an extra space. There's also a missing "(". Try:

SELECT PADR((Aanhef.dear_desc) - (" " + ALLT(Persoon.dsp_naam)), 80) ...

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[Olaf Doschke]

Hi MdVries!

Nobody explained, why

LEFT(Aanhef.dear_desc,LEN(Aanhef.dear_desc)) + Persoon.dsp_naam AS TEST

does not work.

LEN(field) is always the field length, it does count the spaces too, so this call of LEFT() really didn't cut anything from the string.

The - operation on strings is very good in such situations. If you use the Foxtools FLL you can also call REDUCE().

I'd always pad to the length of both fields+1, if that does not exceed the limit of 254 for char fields.
In this situation, where you adress people in letters or emails, 80 chars may be sufficient.

SELECT PADR(Aanhef.dear_desc - (" " + Persoon.dsp_naa),80) ...

or by using Reduce:

SELECT PADR(Reduce(Aanhef.dear_desc + Persoon.dsp_naa),80) ...

Bye, Olaf.