EasyCFM.COM ColdFusion Forums / Other / Need a SQL Statement

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Need a SQL Statement

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

MikeBam
11-05-2004 @ 3:59 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 237
Joined: Jul 2003

I'm not sure - but here is a link that comes in very handy with SQL:

http://www.w3schools.com/sql/sql_functions.asp

Thanks,

Mike

Scarecrow
12-05-2004 @ 6:57 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 109
Joined: Oct 2004

It sounds like you have created a column such as char(100) and want to see what is the largest number of characters in a row for this column so you can then make it say char (80)

The column should be defined as varchar(100).  Then each column for each row will only contain the number of characters required to hold the information.

Ken


Website Designed and Developed by Pablo Varando.