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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

New Help with Query

Status
Not open for further replies.
fooobee

fooobee

Technical User
Nov 13, 2003
33
US
I have to remove all "accounts" beginning with 00, 01, or 02 from the "allowedAccounts" column.

However, these multiple accounts exists for one record.

example of one record.

id allowedAccounts
--- ----------------
001 00_Report234, 01_Report393, 03_Report59

Can someone show me an example of how to do this?
Thanks.
 
Sort by date Sort by votes
first of all i would suggest that you consider redesigning your database...

being said that...

George posted the code for the Split function in this thread183-1120716. Use it to split the values from your table at comma...

hope this helps...

-DNG
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MathiasB
  • Question
Parameterised sql server query
Replies
8
Views
385
Chriss Miller
C
f0rg3tfu1
  • Locked
  • Question
PLSQL Package Help
Replies
0
Views
569
f0rg3tfu1
f0rg3tfu1
peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
1K
Chris Miller
Chris Miller
leifoet
  • Locked
  • Question
Error in Select query
Replies
14
Views
830
Andrzejek
Andrzejek
gussy81
  • Locked
  • Question
Decimal Datatype with negative value
Replies
5
Views
2K
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top