Ignoring blank fields run through SELECT query

[WeeZaliban]

I am using the following SELECT statement to remove unwanted characters from a field. However, if the field is blank, a #Error is populated. Can anyone help me with a workaround for this?

SELECT MID(table.column,Instr(table.column,"badtext")+3,LEN(table.column)-Instr(table.column,"badtext")) AS [New Field] FROM table

As this is, I get the results that I need; but, like I stated before, I get #Error's for fields without entries.

Thanks in advance!

WeeZ

 

[alansidman]

For the null fields, you will probably need to apply the NZ function.

Look at this link

Macromedia Flash (SWF) Movie Created by Camtasia Studio 2

 

[WeeZaliban]

Thank you very much. Worked like a charm.

I ran with the following:

SELECT MID(NZ(table.column),Instr(NZ(table.column),"badtext")+3,LEN(NZ(table.column))-Instr(NZ(table.column),"badtext")) AS [New Field] FROM table