Converting to lower case.

[abe]

How do I convert the field ModelNo to lower case in a
Query?

This is my query Filed1:
Product_url: "http://www.abcde.com/" & [Products]!
[ModelNo] & ".html"

Thanks

 

[Dirk Goldgar]

How do I convert the field ModelNo to lower case in a
Query?

This is my query Filed1:
Product_url: "http://www.abcde.com/" & [Products]!
[ModelNo] & ".html"

You might write

Product_url: "http://www.abcde.com/" & LCase([Products].[ModelNo]) &
".html"

or

Product_url: "http://www.abcde.com/" & StrConv([Products].[ModelNo],
2) & ".html"