Great! works perfectly.

Hi Luis Cazares,

I changed the @MaxLength to 30 and it broke. Can't see anywhere in there with 50, not sure why it broke.

'CLEAN PREVIOUS PRODUCT: FOR DETAILS OF NAME, PRODUCT...

Thank you Lowell. Will have a go at it.

Thanks for the heads-up Luis Cazares. See updated script:

DECLARE @MaxLength int = 50,

@String varchar(max)

SELECT @String = 'CLEAN PREVIOUS PRODUCT: FOR DETAILS OF NAME, PRODUCT CODE, BATCH DETAIL AND ALLERGENS SEE...

Guys, one more thing, it seems like words are being truncated and repeated:

'CLEAN PREVIOUS PRODUCT: FOR DETAILS OF NAME, PRODUCT CODE, BATCH DETAIL AND ALLERGENS SEE CLEANING SHEET'

Try this text,...

Lowell & Luis Cazares, thank you sooooooo much guys.

Much appreciated!

My goodness, you just saved my life. Thank you sooooooooooo much. Works perfectly.

Great, perfect!

But when I add more data, it's not the same.

This is how my data is stored in MSSQL

'***DUST MASK MUST BE WORN***

ENSURE THE PRODUCT CODE AND BATCH INFORMATION...

Hi,

Thank you for this. I ran it but not sure I understand what it does.

I just want to test it with this string of data below at 50 character split,...

We are looking at exporting the data into another system which only allows 50 characters per line, hence the reason for changing it.

The numbering is not required, I added it...

@Markus, I'm new to this, how do you authenticate using a SQL login?

This is my problem:

I'm trying to integrate form/custom authentication with SSRS? basically when a user goes...