How to group concerning the first three letters of my nvarchar field

[Kem Arda]

I just wantto group my records on my telerik reporting.I wantto group records concerning the first three letters of my nvarchar field. I do the following:  

= Fields.HesapKodu Like CStr(Fields.HesapKodu, 0, 3)

When i run my project it throws exception
"An error has occured while processing Report '':
The expression contains undefined function call CStr()."

Could someone pls help me?

[Steve]

Hello Kem Arda,

The built-in CStr function accepts single parameter only and you have provided 3 - this is the reason for the error. Custom implementations of this functionality can be accomplished through user functions.

All the best,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Kem Arda]

Hi,

Thanks for the reply. I resolved it, using MSSQL's built in function SUBSTRING(field, 1, 3).