Archives of the TeradataForum

Message Posted: Wed, 27 Mar 2002 @ 13:51:22 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		teradata newbiee

From:		Anomy.Anom

Hello,

I used to work with Sybase sql. I would like to translate the following sybase sql statement to NCR sql :

   INSERT INTO     vbnprod.dbo.gebruikersnieuw
   SELECT  id,
                   NULL,
                   Substring(full_name ,1,CharIndex(' ',full_name)),
                   Right(full_name ,Char_Length(full_name)-CharIndex(' ',full_name))
   FROM            vbnprod.dbo.gebruikers

I already know there should be a POSITION function but don't know how to use it. I use queryman to generate query's but, is there some function list with explaination and examples somewhere on the internet or some good books i could buy?

Thanks in advance,

Anomy.Anom