Re: converting string value to integer

Manfred Koizar wrote:

>On Wed, 18 Dec 2002 11:13:50 +0000, Ken Guest <kguest@stockbyte.com>
>wrote:
>
>
>>How do I cast/convert a string value to an integer in 7.1.3?
>>I've tried using cast but it doesn't seem to work.
>>
>>
>
><snip>
>
>
>Does this answer your question?  If not, show us an example of what
>you have tried.
>
It does indeed. There were some trailing spaces which I was unaware of,
so I'm now using something akin to
SELECT CAST(TRIM('123 ') AS INT);

which works perfectly.

Thank you Manfred,

ken







________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service. For more information on a proactive anti-virus service working
around the clock, around the globe, visit http://www.messagelabs.com
________________________________________________________________________