VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 VPCart Forum
 description field sql
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

VP-ASP New User

63 Posts

Posted - September 01 2008 :  22:38:45  Show Profile  Visit gledav's Homepage  Reply with Quote
Id like to customise the cdescription (short description) field so it picks up a portion (about the first 150 characters) of the extendeddesc field (Long description) and include a few dots at the end. I think I know how to write the sql to generate this: Left([extendeddesc],150)&""&"..." but I'm not sure where abouts to put it. Can anyone help?
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000