Wildcard asterisk character ("*") in SQL database

Can we use the asterisk character * for a 开发者_C百科search action in SQL database?

MASQLComm = New SqlCommand("SELECT COUNT(*) AS [RecCount] 
                              From " & tName & " 
                             WHERE " & tName & fName & " = '" & {*} & ".Temp' ", 
                            SQLConn)

Please advice me with a code for this.

For text you need LIKE with '%'. But make sure you're acquainted with Bobby Tables. http://xkcd.com/327/

Use LIKE operator to do that.

Also I would strongly recommend against building your SQL query like that. Do it if there is no other way.