[thelist] simple query building question

[Casey]

In a web matrix datagrid, I need a variable WHERE clause.

SelectCommand="SELECT * FROM MCCIME_Doctor WHERE state = 'CA' "

that works fine, but

SelectCommand="SELECT * FROM MCCIME_Doctor WHERE state = ' " & get_state & "
' "

does not work.  Not sure if it's because I'm declaring the variable wrong,
of if my syntax is wrong.

<script runat="server">
 Sub Page_Load(Src As Object, E As EventArgs)
  dim get_state as string = request.querystring("state")
 end sub
</script>

"The server tag is not well formed" is the error.