SELECT ZipCode FROM vu_Zipcodes WHERE ZipCode = '#Trim(Arguments.zipcode)#' SELECT ZipCode FROM Zipcodes WHERE (City = '#Trim(Arguments.city)#' OR CityAlias = '#Trim(Arguments.city)#') AND State = '#Trim(Arguments.state)#' AND ZipCode = '#Trim(Arguments.zipcode)#' SELECT City, State FROM Zipcodes WHERE ZipCode = '#Trim(Arguments.zipcode)#' SELECT ZipCode FROM vu_Zipcodes WHERE City = '#Trim(Arguments.city)#' AND State = '#Trim(Arguments.state)#' EXECUTE sp_CalculateDistance '#Trim(Arguments.zipcode1)#', '#Trim(Arguments.zipcode2)#' EXECUTE sp_RosterPropertyRadiusSearch '#Trim(Arguments.zipcode)#', #Trim(Arguments.miles)# SELECT County, State FROM vu_Zipcodes WHERE ZipCode = '#Trim(Arguments.zipcode)#' SELECT AreaCode FROM vu_Zipcodes WHERE ZipCode = '#Trim(Arguments.zipcode)#' AND PrimaryRecord = 'P' SELECT TimeZoneName, TimeZoneAlias, CurrentTime = (SELECT DATEADD(hh, TimeZoneOffset, '#DateFormat(Now(), "yyyy-mm-dd")# #TimeFormat(Now(), "HH:mm:ss")#')), DayLightSaving FROM vu_Timezones WHERE ZipCode = '#Trim(Arguments.zipcode)#'