Archives of the TeradataForum
Message Posted: Wed, 27 Mar 2002 @ 13:51:22 GMT
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|