ASP Select description from large string

You can use below code to select the first n of chars from a string.

This can also be done from an ASP string. (not tested but the command is still left.) – Select LEFT(ColumName,1) fromĀ TableName where id = ‘100’ ?? Anyone care to confirm?


<%
String1="MyText"
response.write(LEFT(String1,3))
%>

  • Result is MyT
Print Friendly, PDF & Email
  1. No comments yet.

  1. No trackbacks yet.