Thread: query problem
View Single Post
  #4 (permalink)  
Old September 8th, 2003, 05:04 AM
chrislepingwell chrislepingwell is offline
Friend of Wrox
Join Date: Jun 2003
Location: London, , United Kingdom.
Posts: 132
Thanks: 0
Thanked 0 Times in 0 Posts

Possibly you'd be better off using the nTRIM Functions

RTRIM(LTRIM(contractno)) ='" & contractno& "'",cn,1,2

There are two secrets to success in this world:
1. Never tell everything you know
Reply With Quote