Post
Ask Question
Bill

Bill

  • NA
  • 2
  • 0

OLEDB Command

Jan 16 2010 2:03 PM 
 
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)