Click here to Skip to main content
       

Database

 
AnswerRe: No new tables in database after executed query PinmemberJammoD8710-May-13 21:36 
GeneralRe: No new tables in database after executed query PinmemberMember 991209111-May-13 3:51 
QuestionER Diagramming Tools - which one to use Pinmemberole.Grossklaus@gmx.de10-May-13 2:37 
AnswerRe: ER Diagramming Tools - which one to use PinprofessionalJörgen Andersson12-May-13 8:01 
NewsNew Built-In functions in 2012 PinmemberKarthik_J, Coimbatore10-May-13 2:24 
GeneralRe: New Built-In functions in 2012 PinmvpRichard MacCutchan10-May-13 4:05 
GeneralRe: New Built-In functions in 2012 Pinmemberjschell10-May-13 8:00 
QuestionCannot Find Rows With % character in Text Fields with Access SQL PinmemberJohnBlocker8-May-13 10:01 
I am using an Access 2000 database file. When parsing user input that has SQL reserved characters, I put [] around any reserved characters I find. This works fine, except when dealing with %s.
 
I have a table named "Foo", with two rows:
Type as text, SubType as text, with two rows of values:
 
"Sales Tax (%)", "NY"
"Sales Tax (%)", PA"
 
When I execute the following:
SELECT * From Foo WHERE Type LIKE '%Sales Tax ([%])%'
 
I get the rows returned I expect, where the row has a value in the Type column of "Sales Tax (%)"
 
But when I execute:
SELECT * From Foo WHERE Type = 'Sales Tax ([%])'
 
No rows are returned
 
Even if I omit the parenthesis around the % sign, it does not find the rows.
 
Is there something odd I am doing wrong, perhaps specific to Access SQL?
AnswerRe: Cannot Find Rows With % character in Text Fields with Access SQL [modified] PinprofessionalJörgen Andersson9-May-13 9:34 
GeneralRe: Cannot Find Rows With % character in Text Fields with Access SQL PinmemberJohnBlocker9-May-13 22:15 
GeneralRe: Cannot Find Rows With % character in Text Fields with Access SQL PinprofessionalJörgen Andersson10-May-13 4:51 
AnswerRe: Cannot Find Rows With % character in Text Fields with Access SQL PinprofessionalRichard Deeming10-May-13 1:39 
AnswerRe: Cannot Find Rows With % character in Text Fields with Access SQL Pinmemberjschell10-May-13 8:02 
AnswerRe: Cannot Find Rows With % character in Text Fields with Access SQL PinmemberFabricio Dos Santos Antunes10-May-13 15:22 
Questionrule of DataAdapter Pinmembermessages7-May-13 21:10 
AnswerRe: rule of DataAdapter PinprofessionalPIEBALDconsult8-May-13 4:59 
GeneralRe: rule of DataAdapter Pinmembermessages8-May-13 8:47 
GeneralRe: rule of DataAdapter PinprofessionalPIEBALDconsult9-May-13 4:35 
GeneralRe: rule of DataAdapter Pinmembermessages9-May-13 5:16 
Questiondifference between with and temp table in my two query Pingroupmehdi.sabet7-May-13 9:02 
AnswerRe: difference between with and temp table in my two query PinmvpEddy Vluggen7-May-13 9:40 
AnswerRe: difference between with and temp table in my two query PinprofessionalJörgen Andersson8-May-13 11:52 
AnswerRe: difference between with and temp table in my two query PinmemberFabricio Dos Santos Antunes10-May-13 14:55 
QuestionExport Image from SQL to png Format Pinmembermrfalk7-May-13 8:09 
AnswerRe: Export Image from SQL to png Format PinmvpEddy Vluggen7-May-13 9:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web03 | 2.8.141022.2 | Last Updated 23 Oct 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid