can we do string manipulation on a parameter?
I populated a parameter list with dataset.
The parameter @type_year has items look like
"plan_2000" or "Actual_2000".
Now my question is, if we can use some string function targeting @type_year in the query.
something like "select ...... from ... where
year=getyear(@type_year) and type=gettype(@type_year)" ?
Please let me know if you know the feasibility. Thanks.
|
