I have been creating reports, and training clients to write their own reports using SQL Server Reporting Services, and until know, I have never noticed the function GetChar.
For those of you who are not aware of this function, in SSRS it is described as follows:
Returns a Char value representing the character from the specified index in the supplied string.
In lay mans terms GetChar, allows users to extract a character from a specific position in a text string.
=GETChar(Tablename!FieldName.Value, 8)
Granted I could have used the Mid() function, but this is so much cleaner
If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us |