Re: Indexing properties that belong to types

Ryan wrote:

I can do this:

SELECT t.trade_ref, t.trade_date
FROM trades t
WHERE t.sub_trade.st_ref LIKE 'B00000001'

You can?

Equals I could understand ... '%B00000001%' I could understand.

But like without wildcard characters?
--
Daniel A. Morgan
http://www.psoug.org
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)
.

Relevant Pages

  • Re: Melky
    ... :> Ryan wrote: ... then cashman's dumber than we thought. ... Unless he trades one of the OFs, which won't happen, trading ...
    (alt.sports.baseball.ny-yankees)
  • Re: Problem assigning value to empty string
    ... If your res_id equals NULL, then the COUNT function simply skips this row. ... Dejan Sarka ... "Ryan" wrote in message ... Heres a segment of the code I have so far, ...
    (microsoft.public.sqlserver.datamining)