hi,

please try this.

select distinct A.A, case when A.A = B.B then B.B else 'null' end as B from

(

select COLUMN_NAME as A from

information_schema.columns

--pass first table name

where...

hi,

use the full-text functionality of the sqlserver 2005. check this link

http://amitpatriwala.wordpress.com/2008/08/11/fulltext-search-in-sqlserver-2005/[/url]

might be useful to you.

thnx

hi,

your code is working perfect.

you set the variable value to it's condition then what to do.

SET @i = 5

SET @j-2 = 3

SET @name ='test'

WHILE @i > 0

BEGIN

print @i

...

A thesaurus query uses both a language-specific thesaurus and the global thesaurus. First, the query looks up the language-specific file and loads it for processing (unless it is already loaded)....