Hi all,

is there a way to concatenate two fileds in easy SQL

Such as cprpd101.fite = " " & tcibd001.item
cprpd101.fite = 50 char
tcibd001.item = 47 char

or does anyone have alternatives for this?

Thanks in advance!

I have never tried something like this in Easy SQL, but you could always do it in the report script. Something like:


detail.1:
before.layout:
if cprpd101.fite = " " & tcibd001.item then
lattr.print = false
endif


Or you could even use shiftl$ and strip$ to compare them. This is all I can think of at this time.

Mark

Following works in easy sql:

select tiitm001.*
from tiitm001
where tiitm001.item(1;3) = "800"
and tiitm001.item(4;3) = "415"