Skip to main content
Inspiring
August 9, 2006
Question

stripping out spaces in dynamic text fields?

  • August 9, 2006
  • 1 reply
  • 254 views
Hi,
How do I alter this to hide any white spaces:
<%=(rsRecordset.Fields.Item("nvarcharfield").Value)%>

For example, if the nvarchar field contained "Mr J R Ewing", this would
display on the page as:
MrJREwing

Can't find anything on this.

Thanks.
Nath.


This topic has been closed for replies.

1 reply

Participating Frequently
August 10, 2006
Since you are using ASP, use the VBScript Replace function to strip out the spaces, replacing them with nothing, i.e. ""