Hi,
Is there a way to detect the presence of '^Z' character in a field.
I tried using count() function.
But it is not detecting.
Thanks in advance
Savis
How to detect the presence of '^Z' character
Moderators: chulett, rschirm, roy
Exactly how did you use the Count() function? I would recommend
Code: Select all
Count(In.ColumnName,CHAR(26))
The Convert function. You would have to check the syntax, but off the top of my head maybe something like Convert(Char(26)," ",variable)
Jason
Jason
-----
Jason Simon
Consultant / Developer
Attevo, Inc.
http://www.attevo.com/
http://www.projectjlm.com/
http://www.elefoo.com/
Jason Simon
Consultant / Developer
Attevo, Inc.
http://www.attevo.com/
http://www.projectjlm.com/
http://www.elefoo.com/