Substrings with SQL fields

[Guest_imported]

Hi,

I have this Intranet running my ASP page. My problem might be a small one for you experts, but its killing me.


I have a field called Destination. It includes to much data approx 200 characters. I want to reduce the number of characters say like view only the last 50 on the intranet. Its coming from an Access database. I tried Right() Left() but nothing seems right. I go to the ASP code and this is what I do.


Select right(Destination,20) from Travel

with destination being my field name.

Above is just a rough example of what I am doing. I am going directly into notepad and making the changes. Please help.

Thanks

 

[Tarwn]

Well, Unsure why you need to cut down to only 50 characters, but try just selectiong the entire field and then doing the right() on it after you have received it into your recordset. As far as I know, SQL doesn't support substring manipulation. You will have to do that with your ASP code after executing your query and receiving back your recordset.