Im still a learner.

What is "transform data task" is this a different utility to the DTS?

Thanks.

iTS SEEMS GIVING A MAN THE CATH HELPS A GREAT DEAL.

I have located the equivalent method for Oracle its:

+(DATEAPVAL+91) AS EXPIRYDATE

The above adds 91 days to the date value.

Brilliant.

I have created the stored proc dbo.udf_GetFileSize, but I cant see it, where would it be stored.

I have also inserted the following code into my original stored pr

select ........,

path...

I cannot find an sp called xp_getfiledetails in the sp list or the tsql help file.

Besides I would like to run this method against of colum of data returning the...

I simply need to obtain the size of a files sotred on at a location.

If theirs a VBA method it Im sure theirs a related SQL server method similer to...

Heres the quote.......

Microsoft® SQL Server™ 2000 Analysis Services supports many functions in the Microsoft Visual Basic® for Applications Expression Services library. This library is included with Analysis Services and automatically...

its in SQL server TSQL help itself.

Type in "Visual Basic for Applications functions" I cnat find the link to the Books Online via the web

Thank you to Corey Perkins for the Format() method.  But this seems to run very slow on a dataset of 15000 records.

Does anyone know of a faster method I can...

Thanks guys for all your replies.

I think I will have to search for help with manipulating images and remove Sql Server from the arguement.

ANyway:  I hear all this talk about...

Thanks for the reply Andrew,

I have no control over the location of the images.  This has been setup by our corporate supplier.

The images are stored as .tiffs.  What do you...

Ive fixed it.  Special Thanks to Remi.  I used the Primary Key and the Me.Find method.

Many thanks.

thanks guys for the reply. 

I think Im looking for something more like this.

http://support.microsoft.com/default.aspx?scid=kb;en-us;97181#toc

But I need to find it for Visual Basic v6 and above.

Any thoughts.