SQL SELECT * Question

[PCX]

I hope this is not too much of a newbie question.

I saw in some examples in this forum the useage of the:

sqlString = "SELECT *"

Could someone explain (or refer me to a URL) what that is and how it works?

Is it a wild card for using the SQL statement or something else?

Thanks

 

[jebry]

Hi!

It means in this case to select all of the fields in the table for the query. If you have more than one table in the query then you need to specify Select Table1.* means select all of the fields from table 1.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[IFELSETHEN]

Hi, this is a wildcard for selecting all your fields in your table. While this might be a great shortcut, you can get into a speed issue if you have a lot of fields. It's better to call out only the fields that you really need.

HTH, John