Thanks.

Yaniv

Hi Ian,

The main reason for not 'wanting' to list all column names is :

'app adds and removes columns from the table'.

True, I'm lazy but not that laze ....

Anyway, I allready...

OK

Thanks Rajesh

But what if CustText contains more then 8000 ?

I have decided to go with dynamic sql

Thanks

But I don't know the server name nor the database name.

these stored procedures supposed to be executed in any server

Hi Vladan ,

I tryed what you said.

It works.

Thanks

I'm not sure I can use it.....

I also need columns from CRM_MTL .....

Here is an example of what I mean :

SELECT

 (

 SELECT RIGHT(CM_SADE,5) AS TACHAZIT FROM CRM_CFM

 WHERE CM_KOVETZ = 2 AND CM_SUG = 1 AND CM_MAF_MAKOR = MT_NUMERATOR AND CM_SHURA = 5

&nbsp