By 'simple', I presume you mean without going through the packages and editing the meta data manually? I'm afraid the answer is 'no'.

You are calling the function wrongly. Try this:

select dbo.t1('test')

You have to CREATE the function before you can ALTER it.

Duplicate post. Replies here.

Just as a riposte to your fish-frying...

herladygeekedness (8/2/2012)

---

Not talking about the result, talking about the length argument.

I created a simple expression using -2 as length and was unable to save the expression due to...

herladygeekedness (8/2/2012)

---

Devesh_Srivastava (8/1/2012)

---

substring ("Archive_Full_20120731200002",1, (FINDSTRING( "Archive_Full_20120731200002","Full_", 1)-2))

Then how come the above expression is working where the exact string is used instead of a variable and still negative value is accepted!!!...

Can you post the full text of the error message?

Mister Ken (8/1/2012)

---

I'm working with a DataFlow Task and have the souce and destinations set.

The destination has Field1, Field2, Field3 and a last column called dtEndDate.

The source has Field1,...

It looks like a dynamic crosstab query might help. Have a look here[/url] for an example.

Works for me. I suspect that you may have got your variable syntax wrong. Here is my version:

Substring (@[User::TestString],1, (FINDSTRING(@[User::TestString] ,"Full_", 1)-2))

Please post the expression which you tried - the one which gives the error.

Not possible without access to the MS developers.

laurie-789651 (8/1/2012)

---

Having looked at the article, it looks like the 'AS' clause is in the wrong place. It should be like this, I think

SELECT a.DayCount,

...

mrichardson 57577 (7/31/2012)

---

this is working now.

used:

SELECT TOP 100 PERCENT

WebFormData_2.FieldValue AS Surname,

WebFormData_7.FieldValue AS SpecialReq

FROM db.R

JOIN db.WebFormData WebFormData_2

ON db.R.WebFormRowId = WebFormData_2.WebFormRowId

and WebFormData_2.WebFormFieldId =98

left JOIN db.WebFormData WebFormData_7

ON db.R.WebFormRowId = WebFormData_7.WebFormRowId

and WebFormData_7.WebFormFieldId...