0
Answer

OLEDB Command

Bill

Bill

14y
3.1k
1 
 
OleDb.OleDbCommand("Select *, (([AddressDisplay])& ',' &([City]) & ', ' &([State])&',' &([ZipCode])) AS Address, IIf(IsNull([BathsQuarter]),0,[BathsQuarter]*.25)+ IIF(IsNull([Bathshalf]),0,[Bathshalf]*.5)+ IIf(IsNull([Bathsthreequarter]),0,[Bathsthreequarter]*.75)+ IIf(IsNull([BathsFull]),[BathsTotal],[BathsFull]) AS BATH From " & Me.OpenFileDialog1.SafeFileName & " Where ListStatus <> 'Closed Sale'", con)

I need help writing a command statement to remove part of a string in one of my fields
 
City has some abbreviation in it i need to remove
example:  Houston (HST)  i need to remove the (HST)

Next Recommended Forum