This is my style as well. I personally find using the _ underscore cumbersome and have just never got around to using it. I do mix Caps & Small letters to differentiate the elements of a field name.
Russell ----- Original Message ----- From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 19, 2004 9:01 AM Subject: RE: Field Naming > Again, its all personal choice. I usually steer well clear of underscores > as a rule as it can be hard to distinguish between multiple underscores.. > > Normally we go for the following approach: > > Tables : tblEventSettings > > And column names using Hungarian Notation (which has its adversaries > too!): > > vcName > cName > iProductID > dDateInserted > > etc.... > > the same for Store Procedures: > > [app]sp_[Get..Update..Delete][Feature] > > N > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181848 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

