SQL Select statement wont return char fields only numeric fields
I have been racking my brain over this all day today.
I have the following ASP code that uses a Request.Querystring input from a dropdown box 
to launch a select statement. The querystrinch does show in the ?= URL but will only work on 
columns in the Microsoft SQL DB that are numeric. I cant lookup names or simple 3 character fields.



    CODE:
    If Request.QueryString("m") > 0 Then
	filterID = Request.QueryString("m")
	filterColmn = "imDegree"
      Else filterID = 0
    End If

    If filterID > 0 Then
         SQlQuery = "SELECT * FROM v_InternImport WHERE iID IN (SELECT iID FROM v_InternImport WHERE " &   filterColmn & " = " & filterID & ")"
      End If
    End If

I understand that this select statement as a sub select stament in it but I cant even get a staight reuturn from my DB. The select statement references the same view that populates the main asp page that loads before and the shows fine? 

SQL Select statement wont return char fields only numeric fields
===

I have been racking my brain over this all day today.
I have the following ASP code that uses a Request.Querystring input from a dropdown box 
to launch a select statement. The querystrinch does show in the ?= URL but will only work on 
columns in the Microsoft SQL DB that are numeric. I cant lookup names or simple 3 character fields.



    CODE:
    If Request.QueryString("m") > 0 Then
	filterID = Request.QueryString("m")
	filterColmn = "imDegree"
      Else filterID = 0
    End If

    If filterID > 0 Then
         SQlQuery = "SELECT * FROM v_InternImport WHERE iID IN (SELECT iID FROM v_InternImport WHERE " &   filterColmn & " = " & filterID & ")"
      End If
    End If

I understand that this select statement as a sub select stament in it but I cant even get a staight reuturn from my DB. The select statement references the same view that populates the main asp page that loads before and the shows fine? 
