Hi Luis

I need to remove any reference to colour from this string column

ie this "Calvin Klein Men's 3 Pack Trunks - Black/White/Grey Multi" would become this "Calvin Klein Men's 3...

Are you adding it to a table if you only ad the field on to the the body you will only get the first value returned

Hi Have you tried to install a barcode font we use that to format the field varchar data into a barcode so we don't need to have images it works...

Hi Rod

If the look up table is in the database can you include it in your data set from the query I tend to create all the data for the...

Thanks Sean your solution worked also

Thanks Cadavre that did the trick thank you very much 🙂

John Mitchell-245523 (6/9/2011)

---

Simon

Since Gail and I have taken the time to help you, and in case anyone else is reading this in the future with a similar problem, please will...

Thanks John and Gail sorted 🙂

This issue has now been fixed

Thanks

Hi Paul

Many thanks I will do and thanks again for the code

Hi Paul

Many thanks that works brilliantly sorry to be a pain but I need to do the same for time also

the time is stored in the same way ie...

Thanks Kingston

I used this code sction on the actual table

Have a nice weekend

SELECT AN_CODE2,

SUM( CASE WHEN AN_CODE1 = 'CAP' THEN [VALUE]...

Many thanks for the help sorted now 🙂