At 08:56 PM 12/03/2008, you wrote:

>I want to parse for tab in a VARCHAR(512) via a stored procedure.
>Parsing functions when i parse for normal characters, but i don't know
>how to compare a character from a substring of my VARCHAR(512) to a
>tabulator control character.

2 ways:

1.

..
declare tabchar char = ' '; (Strike the Tab key once between the quotes)

or
2. Use the UDF ascii_char (prior to Fb 2.1) or the internal function ascii_char (2.1 and onward):

declare tabchar char=ascii_char(9);

Usually SUBSTRING won't find the character you are looking for. An SQL CONTAINING expression will find it, e.g.

...WHERE MyColumn containing :tabchar

./heLen