Jerry Stuckle wrote: > monkeys paw wrote: >> Assuming there are records in the bills tables where >> the id field is "AK2009H45", why doesn't the following >> statement work?
On 7 Nov, 22:49, monkeys paw <u...@example.net> wrote:
> Jerry Stuckle wrote: > > monkeys paw wrote: > >> Assuming there are records in the bills tables where > >> the id field is "AK2009H45", why doesn't the following > >> statement work?
> >> select * from bills where id like "AK*45";
> > Because asterisk is not a wildcard in SQL.
> > Check the documentation for the LIKE clause.
> Ah yes, thanks. So '%' is wildcard now.
"now"? It has been for as long as I have coded SQL!
Captain Paralytic wrote: > On 7 Nov, 22:49, monkeys paw <u...@example.net> wrote: >> Jerry Stuckle wrote: >>> monkeys paw wrote: >>>> Assuming there are records in the bills tables where >>>> the id field is "AK2009H45", why doesn't the following >>>> statement work? >>>> select * from bills where id like "AK*45"; >>> Because asterisk is not a wildcard in SQL. >>> Check the documentation for the LIKE clause. >> Ah yes, thanks. So '%' is wildcard now.
> "now"? It has been for as long as I have coded SQL!
At least since the late 70's :)
-- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstuck...@attglobal.net ==================
Jerry Stuckle wrote: > Captain Paralytic wrote: >> On 7 Nov, 22:49, monkeys paw <u...@example.net> wrote: >>> Jerry Stuckle wrote: >>>> monkeys paw wrote: >>>>> Assuming there are records in the bills tables where >>>>> the id field is "AK2009H45", why doesn't the following >>>>> statement work? >>>>> select * from bills where id like "AK*45"; >>>> Because asterisk is not a wildcard in SQL. >>>> Check the documentation for the LIKE clause. >>> Ah yes, thanks. So '%' is wildcard now.
>> "now"? It has been for as long as I have coded SQL!
> At least since the late 70's :)
yea, i've been using '*' since the late 80's, i've been diverted by the multiplicity of languages and syntaxes over the years
> Captain Paralytic wrote: > > On 7 Nov, 22:49, monkeys paw <u...@example.net> wrote: > >> Jerry Stuckle wrote: > >>> monkeys paw wrote: > >>>> Assuming there are records in the bills tables where > >>>> the id field is "AK2009H45", why doesn't the following > >>>> statement work? > >>>> select * from bills where id like "AK*45"; > >>> Because asterisk is not a wildcard in SQL. > >>> Check the documentation for the LIKE clause. > >> Ah yes, thanks. So '%' is wildcard now.
> > "now"? It has been for as long as I have coded SQL!
> At least since the late 70's :)
Which is before I started coding SQL. I'm only (relatively) young!
monkeys paw wrote: > Jerry Stuckle wrote: >> Captain Paralytic wrote: >>> On 7 Nov, 22:49, monkeys paw <u...@example.net> wrote: >>>> Jerry Stuckle wrote: >>>>> monkeys paw wrote: >>>>>> Assuming there are records in the bills tables where >>>>>> the id field is "AK2009H45", why doesn't the following >>>>>> statement work? >>>>>> select * from bills where id like "AK*45"; >>>>> Because asterisk is not a wildcard in SQL. >>>>> Check the documentation for the LIKE clause. >>>> Ah yes, thanks. So '%' is wildcard now.
>>> "now"? It has been for as long as I have coded SQL!
>> At least since the late 70's :)
> yea, i've been using '*' since the late 80's, i've been > diverted by the multiplicity of languages and syntaxes > over the years
With what - MS SQL? Not in any ANSI standard SQL.
-- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstuck...@attglobal.net ==================
Jerry Stuckle wrote: > monkeys paw wrote: >> Jerry Stuckle wrote: >>> Captain Paralytic wrote: >>>> On 7 Nov, 22:49, monkeys paw <u...@example.net> wrote: >>>>> Jerry Stuckle wrote: >>>>>> monkeys paw wrote: >>>>>>> Assuming there are records in the bills tables where >>>>>>> the id field is "AK2009H45", why doesn't the following >>>>>>> statement work? >>>>>>> select * from bills where id like "AK*45"; >>>>>> Because asterisk is not a wildcard in SQL. >>>>>> Check the documentation for the LIKE clause. >>>>> Ah yes, thanks. So '%' is wildcard now.
>>>> "now"? It has been for as long as I have coded SQL!
>>> At least since the late 70's :)
>> yea, i've been using '*' since the late 80's, i've been >> diverted by the multiplicity of languages and syntaxes >> over the years
> With what - MS SQL? Not in any ANSI standard SQL.
'*' is Informix, i hadn't realized how far the drift was from ANSI
monkeys paw wrote: > Jerry Stuckle wrote: >> monkeys paw wrote: >>> Jerry Stuckle wrote: >>>> Captain Paralytic wrote: >>>>> On 7 Nov, 22:49, monkeys paw <u...@example.net> wrote: >>>>>> Jerry Stuckle wrote: >>>>>>> monkeys paw wrote: >>>>>>>> Assuming there are records in the bills tables where >>>>>>>> the id field is "AK2009H45", why doesn't the following >>>>>>>> statement work? >>>>>>>> select * from bills where id like "AK*45"; >>>>>>> Because asterisk is not a wildcard in SQL. >>>>>>> Check the documentation for the LIKE clause. >>>>>> Ah yes, thanks. So '%' is wildcard now.
>>>>> "now"? It has been for as long as I have coded SQL!
>>>> At least since the late 70's :)
>>> yea, i've been using '*' since the late 80's, i've been >>> diverted by the multiplicity of languages and syntaxes >>> over the years
>> With what - MS SQL? Not in any ANSI standard SQL.
> '*' is Informix, i hadn't realized how far the drift was > from ANSI
Ah, yes, good old Informix. I haven't used it in years; almost completely forgot about it!
-- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstuck...@attglobal.net ==================
monkeys paw wrote: > Jerry Stuckle wrote: >> monkeys paw wrote: >>> Jerry Stuckle wrote: >>>> Captain Paralytic wrote: >>>>> On 7 Nov, 22:49, monkeys paw <u...@example.net> wrote: >>>>>> Jerry Stuckle wrote: >>>>>>> monkeys paw wrote: >>>>>>>> Assuming there are records in the bills tables where >>>>>>>> the id field is "AK2009H45", why doesn't the following >>>>>>>> statement work? >>>>>>>> select * from bills where id like "AK*45"; >>>>>>> Because asterisk is not a wildcard in SQL. >>>>>>> Check the documentation for the LIKE clause. >>>>>> Ah yes, thanks. So '%' is wildcard now.
>>>>> "now"? It has been for as long as I have coded SQL!
>>>> At least since the late 70's :)
>>> yea, i've been using '*' since the late 80's, i've been >>> diverted by the multiplicity of languages and syntaxes >>> over the years
>> With what - MS SQL? Not in any ANSI standard SQL.
> '*' is Informix, i hadn't realized how far the drift was > from ANSI
I remember % in informix..odd that. Maybe my memory is faulty..
|
