Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Parsing string to variables

Author  Topic 

andresuc
Starting Member

2 Posts

Posted - 2007-03-20 : 12:28:58
Hi,

i need to parse a string to several variables.
The main string is like:

xxxxN'variable1'yyyyyyyyyN'variable2'etc...

So, i need to parse the N'xxx' to get the variable.
Is there any simple solution to do it?

Thank you very much,

André.

andresuc
Starting Member

2 Posts

Posted - 2007-03-20 : 13:03:51
Untill now, i only found this answer...i bealive there is a faster way...

http://www.codeproject.com/database/SQL_UDF_to_Parse_a_String.asp

Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-20 : 21:36:43
this ? http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=76033


KH

Go to Top of Page
   

- Advertisement -