Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2011-11-03 : 07:52:05
|
| How is it possible to have an expression as follows:If there is a text for the field, then make the first letter (if it is alphabetic) into a small letter.i.e."The company name" to be "the company name"or"50% of data" to be the same which is "50% of data" because the first letter is not alphabetic.Any thoughts please?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-03 : 07:58:25
|
| you can use LCase function for that------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-11-03 : 08:18:12
|
| solved by doing it in sql.Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-03 : 08:33:35
|
| as per your example you'll have only one upper case letter right. if thats the case wont this be enough?lcase(First(Fields!fieldname.Value,"ds"))------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-11-03 : 08:58:46
|
| Because of other business needs in this field, etc. it was best for it to be done in sql using lcase and substring.Thank you |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-04 : 05:51:33
|
| ok------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
change the first letter to small letter.