Posted by GIS Analyst on 09/29/05 23:03

Hi Simon

thanks for the ideas. I did think about genearting the statement within
a stored procedure but thought I would check to see if there were
standard sql statement to do this first.
One reason for not returning all columns all the time is to avoid
record duplication when the optional fields are included. (Duplicates
apart from the optional field)

Regards

GIS Analyst

• Next in forum: Re: Query Help, thanks!
• Prev in forum: Re: Query Help, thanks!
• Thread view: Re: Controlling fields in a select statement by use of parameters

[Reply to this message]