> What's wrong in the following sql query?
>
>

SELECT spomast.matcode, partmast.DESCRIPT, spomast.spono, procmast.DESCRIPTIO, ;
> 	spomast.sporate, spomast.maincode FROM spomast inner JOIN accmst ON spomast.maincode = accmst.maincode ;
> 	inner JOIN procmast oN spomast.proccode = procmast.proccode ;
> 	inner JOIN partmast ON spomast.matcode = partmast.partno where spomast.maincode = '136S05'

>
> with this query no records are selected - where as if "where" clause is removed all records are selected.
>
> Ulhas Amrite

I think Tushar is right

try it with

 where upper(alltrim(spomast.maincode)) == upper(alltrim('136S05'))

regards

Marc