>Hi - I was wondering - I am am passing variable strings to an SQL select statement like this...
>
>Select * from customers where &lcString into cursor temp
>
>I can pass specific values like lcString = "Smith" etc but what do I need to do to return all the records? lcString = * ???

It should be
SELECT * from customers &lcWhere into cusror temp

lcWhere = "where "+ 'FirstName="SMITH"' (this would be returned by your procedure)