Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parsing ntext fields

Status
Not open for further replies.
sgurusha

sgurusha

Programmer
Jan 19, 2001
16
CA
I have a number of ntext fields which need to be parsed. Are there SQL functions available that can do this for me, without me converting an ntext field to nvarchar field?

Nubbie to SQL Server 2000.

Thanks.


Regards,
SWG.
 
Sort by date Sort by votes
What's been done is drop-down values for the front-end have been put into an ntext field in the database, Each value is separated by a comma. I need to parse the this to fill a reference table to drive another front-end.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Joining 2 cast fields together 1
Replies
5
Views
152
Cpreston
Cpreston
Cpreston
  • Locked
  • Question
Go back a Year using year and Month fields 3
2 3
Replies
40
Views
627
JeffModen
JeffModen
jimoo
  • Locked
  • Question
Need to Comma Separate Multiple Fields together
Replies
3
Views
159
Mike Lewis
Mike Lewis
sardine53
  • Locked
  • Question
SQL Max with Fields from 2 Other Tables
Replies
10
Views
179
Andrzejek
Andrzejek
leifoet
  • Locked
  • Question
How to filter date fields by month?
Replies
4
Views
137
leifoet
leifoet

Part and Inventory Search

Sponsor

Back
Top