Many thanks for everyone's replies and suggestions. I'm about to leave work now for the weekend so i will have a look at your suggestions over the next couple of...

Figured it out 🙂

Thanks again. P

CREATE TABLE PS_Test

(

cnt varchar(255),

code varchar(255),

tn varchar(255),

);

--SELECT * FROM dbo.PS_Test

--GO

DECLARE @sql nvarchar(max);

DECLARE @tbl TABLE (ID VARCHAR (255))

-- List of tables to...

Many Thanks for your reply.

I have got it working but now i need to export the results into a table so i can monitor the results daily via an...

I'm no expert with SSIS but i know my way around. which would be the best item from the toolbox list to use to get me started?

Regards

Many thanks, works a treat.

Regards

Hi, once the number have been extracted from the free text field then they will be used against a reference table to give meaning.

I know that holding reference values...

In response to previous post....

unfortunately the numbers could be anywhere in the field and there could be up to a max of 5 numbers.

for example one field could be...

More than 2 numbers is where the problems lies. !!!

I would like to have them showing as separate fields but there should never be more than 5 sets of numbers...

Never more than 5 characters as per 1st post.

so the ASCII string will be at most 15 charcters long i guess thus not causinga problem for the numeric (18)...

Hi,

Sorry for the delay in responding (meetings Urgghh!!! )

i have yet to try the suggested solutions. I will let you know how i get on.

One of you asked as to...

Many Thanks for everyone's help and advice. All sorted now, thanks to your advice.

Regards

Thanks for both of yor replies, Works a treat.

I have landed at work this morining to be presented with the full picture.

same table layout but apparently we have...

Hi, you are not wrong, I'm trying to do it form memory and so probably have script wrong.

What need is an expression that works out the average for...

sorted, ignore. Thanks

Many Thanks