vb6 sql search whole table

Page 1 of 1

2 Replies - 539 Views - Last Post: 30 November 2012 - 08:00 AM Rate Topic: -----

#1 skyshare  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 5
  • Joined: 27-November 12

vb6 sql search whole table

Posted 27 November 2012 - 06:56 AM

I have an access table with 20 fields with a VB6 connection. Is there a way to search all fields in the table for an item of text without referencing each field individually?


I am trying to avoid the following...

Select * from <tablename> where field1 ='text' or field2 = 'text' or field3='text'....etc


thanks
Is This A Good Question/Topic? 0
  • +

Replies To: vb6 sql search whole table

#2 maj3091  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 299
  • View blog
  • Posts: 1,768
  • Joined: 26-March 09

Re: vb6 sql search whole table

Posted 27 November 2012 - 07:54 AM

You might be better asking a mod to move this to the database forum, as I think you're looking more at a SQL question than a VB one.
Was This Post Helpful? 0
  • +
  • -

#3 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 8918
  • View blog
  • Posts: 33,437
  • Joined: 12-June 08

Re: vb6 sql search whole table

Posted 30 November 2012 - 08:00 AM

Please avoid opening duplicate topics. If you needed this moved click the 'report' button and type in where you need a mod to move it.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1