123 Eng

Engineering the engineers™


Latest Jobs   Forum Map

 


Home

Source Codes

Engineering Colleges

BE Students

Training  Reports (updated)

Seminar Reports (updated

Placement Papers (updated)

Forums

   Computer Science / IT

   Electronics

   Electrical

   Mechanical

   Chemical

   Civil

   CAT / MBA

   GMAT / Foreign MBA

Latest Jobs

Engineering Jobs / Technical Jobs

Management Jobs

Sitemap

About-Us

Terms of use

Displaying  Source Code(s)  
 

 
What is wrong with 'LIKE *'?

--------------------------------------------------------------------------------



ADO uses % for wildcard translation, not *. Therefore, if you use * as a wildcard, the query will actually be searching for records that have a literal * in the field data. Also, you should use _ instead of ?. Access natively supports % and _ (in addition to * and ?), so it is recommended to use those everywhere instead of being forced to worry about statement conversion when web-ifying anything.

--------------------------------------------------------------------------------
 

 

 

Contribute content or training reports / feedback / Comments
job placement papers
All rights reserved copyright 123ENG