Spliting coloum data

[silicon]

MyColumn contain data like "pqrst#12345"
What will be the sql query in sqlserver 2000 to split the coloumn data as a result like

Coloumn1 Coloumn2
pqrst 12345


Thanks in advance

 

[onpnt]

If you have not tried anything you can start here

http://www.4guysfromrolla.com/webtech/031004-1.shtml

It has also been gone over many times here if you like to search.

[sub]____________ signature below ______________
You may get help by means of code here. Just recall what happens to a rat when he eats the cheese off a rat trap while you're Ctrl+C/Ctrl+V'ing that code as your own[/sub]

 

[silicon]

Thank once again onpnt for guide line.I got the solution from that url.