Database

select * 
from  orders a
where a.customer = 'A'
and ( a.id in (select top(2) id
	       from  orders b
               where b.customer = a.customer
               and   b.id       < 26
               order by b.id desc)
   or
      a.id in (select top(3) id
	       from  orders b
               where b.customer = a.customer
               and   b.id       >= 26
               order by b.id asc))

Brady Kelly wrote:

but insanely undocumented.

SELECT * FROM sysColumns WHERE id = (select id from sysObjects where name = 'myTable');

where file in ('%pdf', '%rtf', '%doc')

select Name from data where id=67 and file like '[pdfrtfdoc]%'

select Name from Grapp1L where Name='suchita' and file like '[pdfrtfdoc]%'

SayamiSuchi wrote:

no i tried both

SayamiSuchi wrote:

is it possible to ...

select Name from data where id=67 and file like 'p%'