View Single Post

   
  #2 (permalink)  
Old 04-08-2008, 10:06 AM
DA Morgan
 
Posts: n/a
Default 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@x.washington.edu
(replace x with u to respond)
Reply With Quote