Hi!
All "alpha" UDFs that you define will become nvarchar(max) in SQLserver regardless if you set the length to 1 or 30. This was not the case in SBO2005 but is how SBO2007 works. Do you know why SAP made this change?
The drawback with nvarchar(max) is that SQLserver doesn't allow you to create separate performance index on such a column (but if it is nvarchar(30) it is ok).
Next question is: can I change the UDF to nvarchar(30) in SQLserver (with the ALTER DATABASE command) without any trouble from SBO?
Regards
Lars