Discussion on:
View:
Show:
Do you frequently use wildcard characters to locate records in Microsoft Access? What other tips would you add to this list?
Nice work, Susan. Your cautions at the end about the differences between Jet and T-SQL are well taken. Anyone have any notion why Microsoft hasn't been more aggressive in promoting the switch to Projects and T-SQL since it makes scaling up to SQL Server so much easier?
One question?
How do I make a query criteria to find a cell in a table that DOESN?T have an ?@? symbol and/or a 'period' to confirm if its an email address?
(ie one cell in a list of emails that is missing the @ symbol and .(period), for instance.. so I can remove invalid email addresses)?
Thank you!
How do I make a query criteria to find a cell in a table that DOESN?T have an ?@? symbol and/or a 'period' to confirm if its an email address?
(ie one cell in a list of emails that is missing the @ symbol and .(period), for instance.. so I can remove invalid email addresses)?
Thank you!
Nice article. I have a question about parameterized SQL statements. I have to implement a simple search on a title field in an ACCESS database. I want the person to be able to put in a word and find all items with that word in the title. what would the SQL statement look like? What would be used to represent the parameter?
Is Is it
SELECT Orders.OrderID
FROM Orders
WHERE OrderTitle LIKE "*?*"
how would I represent a parameter of any string length (I will be asking them to put in a word). For an Access 2003 database? I am using ASP.NET and VB.NET
Is Is it
SELECT Orders.OrderID
FROM Orders
WHERE OrderTitle LIKE "*?*"
how would I represent a parameter of any string length (I will be asking them to put in a word). For an Access 2003 database? I am using ASP.NET and VB.NET
what is the wild card
- Keyboard Shortcuts:
- Prev
- Next
- Toggle
