This was originally written for CS 1.1, but should work with any table that has the PropertyNames and PropertyValues in the column list. Such as aspnet_Profile, cs_UserProfile, as well as cs_Posts, cs_Threads, and cs_Sections.
This can be useful in doing full searches on this text. But it's very costly on the database because you'll have to create a CURSOR to loop through all of your records, select the PropertyNames and PropertyValues from each record, and pass it to this function (or select straight from the FUNCTION in your queries.
Notes from the author (ScottW):
CS uses ExtendedAttributes to allow metadata about a post, user, or section to be stored
in a special ':' delimited format. This enables storing metadata without adding new columns
to any tables, changing sprocs, etc.
However, any data stored in this format is not easily queryable (so use it wisely 
Occassionaly, you may want to query against this data. This function should make that task simple!
Keys are stored in this format: string:S:Int:Int = Key + :S : Starting Location : Length :
An example: 'Theme:S:0:7
ummyTotalPosts:S:7:1:BannedUntil:S:8:21:UserBanReason:S:29:5:'
Values are stored in a single string with no spaces between them.
An example: 'default04/20/2005 12:16:41 AMOther'
Theme starts a 0 and continues for 7 characters (default)
dummyTotalPosts starts at 7 and coninutes for 1 character (0)
BannedUntil starts at 8 and continues for 21 characters (4/20/2005 12:16:41 AM)