Microsoft Sql Server Logo
Microsoft Sql Server Logo . Mar 19, 2021 · the following example shows how to return the first 10 characters from each of a text and image data column in the pub_info table of the pubs database.text data is returned as varchar, and image data is returned as varbinary. 4 designed for xml use. Select pub_id, substring(logo, 1, 10) as logo, substring(pr_info, 1, 10) as pr_info from pub_info where pub_id = '1756'; Includes all (yy) (without century) styles and a subset of (yyyy) (with century) styles. Jun 28, 2009 · summarizing the answers.