Hello.
I need to create a custom enumerate list in order to "merge" all the record that are referred to a precise user.
To be more clear:

In my database I have the table user, in this table I have:
[dbo.User]
[1][USER 1]
[2][USER 2]
[3][USER 3]
[4][USER 1 WEB]
[5][USER 4]
[6][USER 5]
[7][WEB 5 USER]

I wish to create an enumerated list in a way that [USER 1] and [USER 1 WEB] will be considered as the same inside the list and il will be dispay in the filter as [USER 1]. The same for [USER 5] and [WEB 5 USER]. I think that using MSSQL Function can be a way, but I can not understand how to apply them inside seal report.
Initialy I was thinking to use MSSQL replace function, but in the cases like [USER 5] and [WEB 5 USER] I will get to field because the 5 is before USER.

There are maybe other ways or suggestions?

This can be a solution thanks :)
But I am searching for something more generic...
If I do as you suggest, I have to manually fill the:

select case user
when 'USER 1 WEB' then 'USER 1'
when 'WEB 5 USER' then 'USER 5'

in any list, because the user are not always the same, and are not called:
USER 1
USER 2,
USER 3
ecc...

But are called as:
name1 surname1
name1 surname1 web
web surname2 name2
ecc...

Plus is possible that someday a new user will be inserted, and I wish to not manually modify all the enumerated list query.

To be more precise on what I wish to accomplish, I wish to create a function that can be called inside the enumerate list definition and can manage this cases.
Now I do not want you to give me the code, but I need to understand if is possible to create a global function to do this...

Thanks in advance.