From: Kent Dahl <kentda@...>
Date: 2002-12-16T05:19:21+09:00
Subject: Re: strange DB problem

Shannon Fang wrote:
> 
> On Sun, 15 Dec 2002 23:38:42 +0900
> "Mike Campbell" <michael_s_campbell@yahoo.com> wrote:
> 
> > % is the only SQL wildcard I've ever seen...   I'd assumed (uhoh) that it was
> > standard.
> I always thought it was "*" :)) and Access do support "*", is it
> Microsoft problem or mine? :)

Microsoft. The "*" looks like a hankering back to Visual Basic:
http://msdn.microsoft.com/library/en-us/dninvb01/html/ivb0115.asp
"These standard VB characters will also work in Access SQL statements.
However, notice that for SQL Server statements, you'll need to use
different characters entirely. "

<paranoid>
Or maybe it is part of their Evil "Embrace and Extend" plot!
</paranoid>

-- 
(\[ Kent Dahl ]/)_    _~_    __[ http://www.stud.ntnu.no/~kentda/ ]___/~
 ))\_student_/((  \__d L b__/  NTNU - graduate engineering - 5. year  )
( \__\_�|�_/__/ ) _)Industrial economics and technological management(
 \____/_�_\____/ (____engineering.discipline_=_Computer::Technology___)