On Apr 20, 2011 9:48 PM, "SoftTech" <miket@...> wrote:
> Greetings All,
>
> Firebird 1.53 (Still)
>
> I have a CLT_REF_NO like 700317012-0000 or 1586471932548-0500
>
> Using a stored procedure I need to remove the dash and anything after it.
>
> So 700317012-0000 would be 700317012 and 1586471932548-0500 would be
> 1586471932548
>
> Any help or tips appreciated,
> Mike
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>


[Non-text portions of this message have been removed]