Hello,

how can I display the names in a listbox like Geert if in the table the name is stored like geert ...

In access I can use the the function "strconv" but this function doesn't work with SQL server.

So my question is, how to replace the function
"SELECT StrConv(LCase(name), 3) FROM Table" in such a way that ik works in an adp project.

Thanks in advance,
Sven.

As far as I know, SQL Server doesnt have a Propercase equivalent :(

You use UPPER (char_expression).

Hope this helps

Don't think there is a built in function for proper casing but I did find this UDF that might be useful. Link (http://weblogs.sqlteam.com/jeffs/archive/2007/03/09/60131.aspx)

If this is for presentation only then I would recommend letting the presentation layer do the string conversion not SQL.