hi all,
I usually do functional support (BaaN 5.0c) so i apologise for the very low level of my problem :o
I need to do a query (using ttadv3580 and its text editor to paste my sql) it's almost ok but I have an issue ..

let say I have cisli245.item = " 100001213 " (plenty of rubbish space)

in --> select cisli245.item from cisli245 where {whatever}

out of the select I just want a nice "100001213"

basically I want to apply a trim weither out the select or after in the related report ..
I had a look in some other thread but I haven't find out how use the 'strip' and 'shiftl' commands in the select statement (or when editing the report ... )?!


[added to post]
if I try this: select shiftl$(cisli245.item) from cisli245
I have the error message : "table not present in query: shiftl$("
[end of addition]

any help is much appreciated, :)
thanks!

Actually you do not need to modify the query. Are you printing a report? If so then just print shiftl$(cisli245.item). I never change the domain of a field until I print it. You run the chance of confusing domains as you go through the script.

thanks, it works nicely :)