I have this problem. I have two tables from which I want to extrapolate the values, specifically in a field of a table are the ids of the second table separated by;
Using this procedure:

```
SELECT name 
  FROM tab1
 WHERE id in (SELECT REPLACE(field,";",",") as idresult 
                from tab2 
               where tab2.id=1)

```

From this query I expect more rows because in the tab2 field there are these values (1;2;3;4;5)

If the same procedure you run without Select Replace I get the correct 
results ie::

```
SELECT name FROM tab1
WHERE id in (1,2,3,4,5) 

```

it's right. Should I use the replacement you have suggestions?