drmichaelw
IS-IT--Management
I have a select statement that includes [part id]
The excel table that I am linking to has "dirty data". Some [Part Id] have been assigned 0,00,000,0000,etc. [Part Id]is text not a number. I am performing a COUNT function on [Part ID] and it counts the [Part Id} with the 0,00,000,0000,etc. I want to ignore these values. Is there a way I can typecast the value to an integer and put in my where clause WHERE [Part ID]>0. Or any other ideas. I would like to code in my query as apposed to vbscript.
The excel table that I am linking to has "dirty data". Some [Part Id] have been assigned 0,00,000,0000,etc. [Part Id]is text not a number. I am performing a COUNT function on [Part ID] and it counts the [Part Id} with the 0,00,000,0000,etc. I want to ignore these values. Is there a way I can typecast the value to an integer and put in my where clause WHERE [Part ID]>0. Or any other ideas. I would like to code in my query as apposed to vbscript.