T TjS Registered User. Local time Today, 06:58 Joined Jul 18, 2007 Messages 126 Sep 19, 2007 #1 again maybe a simple question... How to convert a numeric field to a textfield. In Crystal reports quite easy (totext([fieldname]), but don't know how to write in (good) SQL thanks in advance
again maybe a simple question... How to convert a numeric field to a textfield. In Crystal reports quite easy (totext([fieldname]), but don't know how to write in (good) SQL thanks in advance
KenHigg Registered User Local time Today, 01:58 Joined Jun 9, 2004 Messages 13,310 Sep 19, 2007 #2 . . . cstr() ?
T TjS Registered User. Local time Today, 06:58 Joined Jul 18, 2007 Messages 126 Sep 19, 2007 #3 Thank you Thanks!, it works with cSTR([field])