I have to query a from a table something like the following but its not working ???
select invoice,right(i snull(code,'XXX XXXXX'),2) from invoice where invoicedate='20 08-01-04' .

The code field is NULL in most of the results...