asked on

search values inside table

Dear experts -

I have created a table A with 2 columns. I have an other 2nd table where there is column which is varchar. The problem I am trying to solve is

I might have the data in the 2 nd table looks like ' speed is 2 MI per hour'

table A has a mapping MI - Miles. I need to display/ convert as 'Speed is 2 Miles per hour'

Regards

slightwv (䄆 Netminder)

Not sure I understand all the combinations but a simple replace from tableA codes, values in table2 seems like it might work.

A small test case with tables, sample data and expected results would help a lot.

This will likely involve creating a function. Is this an option?

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Aaron Shilo

hi

there is no real solution for your problem that will hold for the long run. (i think all experts will agree)

you need to create another column with the relevant MI KM and any other value you wish to display or manipulate.
it would be perfect if you held a KEYWORD table and code it and reference it.

slightwv (䄆 Netminder)

>>(i think all experts will agree)

I don't agree.

I don't think there is enough information on the actual requirements to even begin to make that comment. Based on the high level requirements listed, the code I posted does EXACTLY what they asked.

akp007

ASKER

Thanks slightwv. Your assumptions were correct. sorry for not explaining the problem clearly

Regards

slightwv (䄆 Netminder)

Glad I guessed right. Glad to help.