Scott Klarenbach wrote:
I have a client that wants to search table fields for strings, and
ignore any-non alphanumeric character in the field. (match only the
alphanumeric portion of the field, and discard the rest)
for example, a search for apple would return true on the following record
a**__-p p
I have a client that wants to search table fields for strings, and
ignore any-non alphanumeric character in the field. (match only the
alphanumeric portion of the field, and discard the rest)
for example, a search for apple would return true on the following record
a**__-p p + l ^^ @e
I have
Hi.
I'm working on a query I would like to sort a certain way. If the search
term matches the start of any word in the title of a book, I want this
result first. If there are multiple matches, I want them sorted by date
submitted. Afterwards I want matches from the book description, and if ther
Hello,
I have a column with a name of a person, say "Franklin D. Roosvelt". Can I
query the table so that the name will be retrieved in the following format:
Roosvelt, Franklin D.
Any help will be appreciated.
--Kevin
-
Befor
