You might find that it's easier to return the full column and then use regular expressions to parse them apart.

-mike

>Hi All,
>
>I want to search a specific value and find out the number before – in a varchar column
>
>The values are :
>
>ProjectNo Notes
>12 1-Ashish,4-Jain,1-Keith
>44 4-ABC,6-Ashish,8-CCC,6-SSS
>45 5-AAA,8-SSS,8-Keith,11-Ashish
>
>
>I want to return the values
>1
>6
>11
>for different project number when I search for string “Ashish” in Notes column.
>
>Thanks
>…ashish