Re[2]: use of substring()

NW> Ooops, reserved word! Works great ;-) NW> Any way to add something to it like "" or should I do that in my NW> php? concat() is your friend! - Julie --> Julie Meloni --> [EMAIL PROTECTED] --> www.thickbook.com Find "Sams Teach Yourself MySQL in 24 Hours" at http://www.amazon.com/exec

Re[2]: use of substring()

>> SELECT datefield, SUBSTRING(textfield, 1, 30) as description FROM >> tablename WHERE id = 2; single quotes around textfield... - Julie --> Julie Meloni --> [EMAIL PROTECTED] --> www.thickbook.com Find "Sams Teach Yourself MySQL in 24 Hours" at http://www.amazon.com/exec/obidos/ASIN/06723