Kaup, Chester
Chester_Kaup at kindermorgan.com
Wed Dec 5 10:54:16 CST 2012
I am calling the following function from a query. I get a type mismatch error at the first record. Value of status is "PA". I don't understand the mismatch. Thanks. Here is the SQL. dbo_DSS_StatusChanges is an SQL server table with status as a data type of text SELECT PID, WellStatus(Status) AS ReturnStatus FROM dbo_DSS_StatusChanges; Here is the function: Public Function WellStatus(Status As String) As String Select Case Status Case "FL" Or "FM" Or "FH", "PL" Or "PM" Or "PH" Or "SL" Or "SM" Or "SH" Or "SP" Or "RL" Or "RM" Or "RH" Or "RP" ReturnStatus = "PRD" Case "CI" Or "WAGC" ReturnStatus = "GasI" Case "WD" Or "WI" Or "WC" Or "WCH" Or "WF" ReturnStatus = "WI" Case Else ReturnStatus = "" End Select WellStatus = ReturnStatus End Function