myString = MyDataTable.Select("SELECT * FROM TableName WHERE ColoumnName = " & "myValueToFind")

i tried this on some different tables and i always get syntax error: missing operand after TableName operator ?

this is a pretty standard query, so i have no idea where the mistake could be...

any ideas?