Aug 19, 2007 #1 hanlee IS-IT--Management Joined Aug 19, 2007 Messages 3 let say i have a column news that have more than 1000 varchar, what should i do if i want to limit the display to only 100 char
let say i have a column news that have more than 1000 varchar, what should i do if i want to limit the display to only 100 char
Aug 19, 2007 #2 r937 Technical User Joined Jun 30, 2002 Messages 8,847 Location CA select left(news,100) from ... r937.com | rudy.ca Upvote 0 Downvote
Aug 19, 2007 Thread starter #3 hanlee IS-IT--Management Joined Aug 19, 2007 Messages 3 thank u ~~ Upvote 0 Downvote