help needed on using substring function

jd · 16 Apr 2010 10:53:44 AM

Hi,

how can I get first letter from N006187 number.

ex: From N006187, I need to show only N letter.

can I get any help on this??

MFGF · 16 Apr 2010 11:24:48 AM

substring([your item],1,1)

jd · 16 Apr 2010 11:58:22 AM

Thanks MFGF..

BSP Software	Resources	About Us
MetaManager	BSP Software Training	BSP Software
Integrated Control Suite	YouTube Channel	Micro Strategies Inc
Security Migration		IBM Cognos
Integrated Management Suite

If you are unable to create a new account, please email support@bspsoftware.com