how to write sql query when I have empty space like "tom teng"

[rouqiu]

Hi,
I want to do a query:

"select * from database where name = "tom teng" "

It is obvious not write to write this in VB. But which character should I use? (e.g. \ or ' )

Thanks

 

[Newbie]

"Select * From tablename where name = 'tom teng'"