exists is faster as many resources says.

i tend to use exists not in.

select * from table1 a

where exists

(select 1 from table2

where table2.po# = a.po#)

already figured it out

thanks anyway

as BOL they both have the same functionalities.

they prevent (not always) the query optimizer from using an index to perform a search.

i hear lot of thoughts about tu use...

ok seems enough for me

what if i have sql server 2000

i have to use Text datatype then

what about Text dataype?

this field will be accessed frequently and very often

select statement will be used often, insert as well

less update and delete...

thats the strict answer i was waiting

10x

yes john its the most clear way to do it

i also did it

but i was just wondering if a query can be written in the way i provided or its...

for a specific ID i have one and only one max (ID)

insert into @table

select 1, 'A', '03/07/07' union all

select 1, 'B', '09/07/07' union all

select 1, 'C', '11/07/07' union all

select 2,...

10x for ur reply

but i gave a simple example here

the real case is that the row contains many fields , some are int, some are varchar....

so i need that whole...

i use this:

CREATE

FUNCTION [dbo].[GetList]()

RETURNS

Varchar(20)