-- in a stored procedure
select IDNum, Street, HouseNum from [Table] WHEE Street = @street
'in VB
"select IDNum, Street, HouseNum from [Table] WHEE Street = '" & street & "'"
//in C#
"select IDNum, Street, HouseNum from [Table] WHEE Street = '" + street + "'";