Hi Kaushik Solanki,
Thanks for your reply.. i think i have my original question wrong though. It seems that i do actually need some of the line type'v' included...
What i need is to exclude linetype 'v' if they are greater than 0
EANCode AS EAN,
Where not wildmatch(LineType,'v') and <0 if that makes sense? So only include linetype v if a negative figure...
How can i write that?