select query on salesforce records
how to run a db select query on salesforce records ?.
thanks in advance !,
Note that you can't perform a Select * from Table
There are different ways to accomplish this. As a first step I would reccomend installing the Force.com IDE http://wiki.developerforce.com/index.php/Force.com_IDE
The IDE is very powerful and you have options to do many things including utilizing the Schema explorer which I think is one of the best ways to search your SFDC data.
Once you are in the Schema Explorer within the Force.com IDE you can run SOQL (note its not SQL) to gather information.
Its a bit different and like TFiel states there is no wildcard you can use in select statements. Aside from that the queries look fairly similar.
Select Id, FirstName, LastName from Contact Where LastName = 'Smith' Limit 2
Developer questions are best asked over at the developer boards which you can find here: http://boards.developerforce.com/t5/Apex-Code-Development/bd-p/apex