If wkStationID = 1 and DistSerb(0) = "", then the statement:

SQLString = "UPDATE StationDet2 SET " _
& "SuperS = " & DistSerb(0) & " " _
& "WHERE Station_ID = " & wkStationID(ListChoice) & ";"

returns SQLString as "UPDATE StationDet2 SET SuperS = WHERE Station_ID = 1"

and this gives me a syntax error.

How can I create SQLString that if DistSerb(0) = "", the SQLString is "UPDATE StationDet2 SET SuperS = " " WHERE Station_ID = 1" ?