SQl Question

[lalitha1]

I have two tables EMP and CUST with columns Empsym and Custsym. I need to join on these fields --- Empsym with the string of symbols in Custsym. Can someone help me with this.
Empsym Custsym
15 16H;42A;23
23 36D;15;24
21A D42;35;XB
D42 65;3B;X6;44;56;14B;21W;21A;15C

 

[gmmastros]

I encourage you to change the structure of your tables. This method for storing a list of sym's is really a bad idea. Please do a little research on [google]Database Normalization[/google]. You'll be glad you did.

I also realize that it's not always possible to change the structure of your tables, so....

Select	* 
From	Emp
        Inner join Cust
          On ';' + Cust.CustSym + ';' Like '%;' + Emp.EmpSym + ';

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[lalitha1]

I do understand that this is not a good idea but this is the business requirement. Appreciate your help.

 

[gmmastros]

If I hadn't put that bit in there about database normalization, I would catch hell from the regulars that read this forum.



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[lalitha1]

I understand. Thanks for your help.