There will only ever be  these Values 

'Feild', 'Part','Solve'' ,info'  if otherwise  the Act_ind = 0

There is my code...

Test it with this

Update [DB_NAME].dbo.Test_1

Set Act_ind = dbo.udf__Test_Act_ind(field_1,field_2)

select * from dbo.Test_1

/* My...

I am not trying to order the items in the table  

Am only looking at the Value1, Value2 and setting the indactor.

Field = 1 ,part = 2, solve = 3

Example  if...

Sorry i think you must have pick me up wrong on the first out set, am not looking to extract data from the table i am writing the function for...

Am trying to find out if the combinction exist then set a value to it 1,2,3 etc

For example if i have the word "field" and "part" in 2 rows where...

Hey Jeff, thanks for the code, am new to UDF so i think its best i stick with what i have for the moment, I've added in comments into the...

Thanks for your help, regards the comments i've added in comments into the code now.. i've 65 UDF in the SQL DB and none of them have comments in them.......

Hey Mike, ok my problem is that i have 2 tables that were being used, for reporting, but these are no longer being used, i can't for the life of...

Thanks its working fine now.

Thanks,

Here is my code.

select ol.supplier_Part_Number,pd.pronum

from dw..products_dim pd

inner join ORDER_LINES ol on ol.supplier_Part_Number = pd.pronum

so how do i intergrate the code into it ?

thanks for your help, this now works like clockwise... cheers...

Thanks but what does the /B do ?

copy E:\temp\Fi*.txt = E:\temp\Coll.txt /B

I have found the problem, when i collaborate all the files that are on the FTP site into one file it adds a funny character into the file...

Sorry i think i put you guys off track with the FTP link i've no problem with it,

I have a DTS, which is a file with or without data collected...

I have so far been working with these two bits of code.. again like you mentioned they are not very reliable.. but they do give me some results... The problem...