Strings and Update Query

[lrfcbabe]

I have a field(text) that contains data of varying string lengths. How can I either formatting the data field or using an Update query to say if the string is less than 10 concatenate until the length equals 10?

Thanks

 

[PHV]

concatenate until the length equals 10
concatenate WHAT ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PWise]

try
left(replace(textfield," " ,""),10)

 

[GingerR]

Or use the String function which pads your item with zeros or blanks or whatever you want

=String(10-Len(FieldName),"0")

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html