Hello;

I have an sql script function that take one text parameter "funct (text)", what 
I need to do is the following:

If the parameter name is string and its value was for example "abcd" then I 
need to do a query based on ab and then based on the abc, how?

Example:

SELECT * from voipdb where prefix like string

But I need the string to be ab and then to be abc? How I can assign the string 
to the first character and then to the first and second? In other words, how 
can I can take part of the string to do query on it?

Regards
Bilal


      

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to