Segregation Data in SQL
<p>I have a complex Id in my Data Base table Like is 00-000-000.
All names store in one field</p>

<pre><code>01-000-000=Warehouse
01-001-000-=Rack
01-001-001=Bin cart 
</code></pre>

<p>into the same table. I want to segregate data in 3 different fields. Is it possible in SQL?</p>