<div>
Thanks for the input. Yeah, I thought this might be the case. &nbsp;I am building the SQL dynamically using PERL, so it shouldn't be a problem to approach it as you suggest.<br />
Never hurts to ask! Thanks.<br />
<br />
--Dave Stephens<br />
<br />

</div>


Thanks for the input. Yeah, I thought this might be the case.  I am building the SQL dynamically using PERL, so it shouldn't be a problem to approach it as you suggest.
Never hurts to ask! Thanks.

--Dave Stephens



<div>
<div class="content wysiwyg-content">
How does one pass a LIKE query to all the fields in a database? &nbsp;For example, the following:<br />
&nbsp; &nbsp; &nbsp;SELECT * from Genetics WHERE Genetics.author LIKE '%smith%'<br />
Returns records with &quot;smith&quot; in the authors field, but what if I wanted to search for &quot;smith&quot; in ALL the fields?<br />
I tried<br />
&nbsp; &nbsp; &nbsp;SELECT * from Genetics WHERE Genetics.* LIKE '%smith%'<br />
And it didn't work (yes, I'm new to SQL).<br />
<br />
Any help would be appreciated.<br />
<br />
Thanks,<br />
<br />
Dave Stephens<br />
<br />

</div>
</div>


How does one pass a LIKE query to all the fields in a database?  For example, the following:
     SELECT * from Genetics WHERE Genetics.author LIKE '%smith%'
Returns records with "smith" in the authors field, but what if I wanted to search for "smith" in ALL the fields?
I tried
     SELECT * from Genetics WHERE Genetics.* LIKE '%smith%'
And it didn't work (yes, I'm new to SQL).

Any help would be appreciated.

Thanks,

Dave Stephens



General SQL Query Question

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.