I am using queries against an Access 2K mdb to create datasets in VB2K5. I am running into issue with the SQL syntax. I can not get the "like" operator to return any rows. So I used a left trim against the field as a work around. However, now I need the Nz function.