Easy question for a query

Oct 15, 2010 0 Replies

I have a couple batches of shirts, 2-3 different styles. When items had been created in my system product descriptions had been left out. I'm familiar and just fine with understanding and writing queries but am lost on one thing.



How the heck do I insert a linebreak into the description? Manually it's cake but time consuming...EG...



update item set extendeddescription = 'blahblahblah(what goes here for linebreak?!)Next line of text... etc...' Pretty simple question really, but yeah! Thanks for your help guys!


------------------------------------- ~~Newbie in way over his head~~//.


Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required